Skip navigation
Contact Us
1947 Views 4 Replies Latest reply: Dec 13, 2012 3:07 PM by kommireddy.nikhila@gmail.com RSS
kommireddy.nikhila@gmail.com 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)

Legend

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