In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

HP,

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

IBM,

There are 10 flat files; out of 10 files 1 file is empty. How do you identify the empty file? How can you load all files into targets?

Accenture,

How do you join more than 3 flat files in informatica?

ITC Infotech,