Skip navigation
Contact Us
4751 Views 4 Replies Latest reply: Dec 13, 2012 3:07 PM by RSS Novice 25 posts since
Oct 8, 2012
Currently Being Moderated

Dec 12, 2012 7:05 PM

Join Data from 2 source qualifiers!

Hello everyone,


I need help with teh following scenario.


-->I have a mapping which has 2 source qualifiers and the data for the 1st one is coming from a table and for the 2nd one is coming from a flat file.

-->SQ of table has columns A,B,C

-->SQ of flat file has columns A,B,C which are hard coded.

-->Both the SQ's are joined to 2 different expressions and then the results of teh expressions are joined to the UNION transofrmation.

-->Now at the flat file I will have to introduce a LOOKUP transformation such that columns A and C come from flat file SQ but column B comes from the data of the 1st SQ.

-->I created the same but I am not able to join the lookup to the expression which has the otehr ports conencted from the flat file SQ.


Below is the picture of where I am struck at.


Can anyone help me with this?


Thanks in Advance.

Nikki.informatica community1.jpg

More Like This

  • Retrieving data ...

Bookmarked By (0)


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