Hello. i'm working in Informatica Cloud. I want to use three SQL tables as a source, a, b and c - where a and b use an inner join, and a and c use a left outer join. i've made various attempts but it tells me that my syntax is bad. can someone provide the proper syntax, or do i need another approach? My latest attempt is below.
CONTACT INNER JOIN CONTACT_ADDTL ON CONTACT.CONTACTID = CONTACT_ADDTL.CONTACTID
LEFT OUTER JOIN INVESTMENT_QUALIFY ON CONTACT.CONTACTID = INVESTMENT_QUALIFY.CONTACTID
Thanks for your time.
Is it possible to get the proper syntax worked out correctly outside of Informatica cloud, not sure what is the specifics of the source DB, you can use the native query tool of the DB you are trying to pull the data from. Hopefully that gives a more meaningful error to help you further along.
Once the correct syntax is complete plug it into the custom source in Informatica cloud.