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?

Showing Answers 1 - 0 of 0 Answers

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