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.
No comments:
Post a Comment
Thank you :
- kareem