Send Flat File Data to Different Targets

How can we send the flat file data to different targets(which are also flat files) based on the name of flat file without adding extra columns?

Questions by jhotsna

Showing Answers 1 - 2 of 2 Answers

sridkaretl

  • Oct 21st, 2011
 

first thing i would like to know is whether the different targets are of same database or not. If the target is from same database then you can use router transformation by importing the flat file into source either as de-limited or fixed width.

  Was this answer useful?  Yes

ETLKaps

  • Apr 10th, 2012
 

For the FlatFiles, in source definition, there is a option to include file name as one of the output port. There is no need to add FileName in actual source file. Informatica will append it to every row during processing. These new rows can be passed through Router to decide to which table data should be loaded.

  Was this answer useful?  Yes

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