Sunday 12 June 2011

How to Process multiple flat files to single target table through informatica if all files are same structure?



We can process all flat files through one mapping and one session using list file.
First we need to create list file using unix script  for all flat file the extension of the list file is .LST.
This list file it will have only flat file names.
At session  level  we need to set
source file directory  as list file path
And source file name as list file name
And file type as indirect.

No comments:

Post a Comment