sridkaretl

 Profile Answers by 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.

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.