Skip navigation
Contact Us
2447 Views 1 Reply Latest reply: Jul 8, 2011 10:54 AM by Elias Sha RSS
chris markiewicz Newbie 6 posts since
Jan 8, 2009
Currently Being Moderated

Jul 5, 2011 2:17 PM

User Defined Join - one inner, one left outer...

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.

Chris

  • Elias Sha Expert 183 posts since
    Jun 3, 2009

    Hey Chris,

     

    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.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points