Informatica

I have 2 sources one is relational table with 7 ports
second is flat file with 8 ports.How can I get the combined output and I should not do any modifications to the source structure?
  • Interview Candidate
  • 1
  • 6006

Showing Answers 1 - 1 of 1 Answers

priyank_divya

  • Aug 3rd, 2012
 

Hi,

I think we can obtain the results by using Joiner transformation. If the sources have no common columns, we can add one extra column with a value 1 in both the sources and then can join based on that column and specify join condition as "Full outer join". All the records from both the sources will go forward.

Hope this helps.

Thanks.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions