Join Flatfile Sources

How to join two flat file and load the data in target using Joiner, Lookup, Source Qualifier.

Questions by contact.manaskumar   answers by contact.manaskumar

Showing Answers 1 - 12 of 12 Answers

mayur.data

  • Apr 1st, 2008
 

Hi

You can Join two falt files using Joiner and as well as Looup. As far as performance is considered Joining using look up would give you better performance.

  Was this answer useful?  Yes

Noel Lastra

  • Apr 9th, 2008
 

Hu! Have you tried joing two flat files before ?

  Was this answer useful?  Yes

Mamta11

  • Jul 26th, 2008
 

Use joiner transformation. If the structure of both the flat files is same you can also use union transformation

  Was this answer useful?  Yes

sakthi.jaganathan

  • Aug 25th, 2008
 

The only way to join two flat file is joiner transformation,
if the structure of the two flat file is same and the datatypes also matches we can use union transformation, but it wont join the flat files, it will merge the flat flies. In informatica the union transformation will act as a unionall function.

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