Loading Multiple Flat Files

Loading Multiple Flat Files 

Suppose we have ten source flat files of same structure. How can we load all the files in target database in a single batch run using a single mapping?

Answer

After we create a mapping to load data in target database from flat files, next we move on to the session property of the Source Qualifier. To load a set of source files we need to create a file say final.txt containing the source flat file names, ten files in our case and set the Source file type option as Indirect. Next point this flat file final.txt fully qualified through Source file directory and Source filename.