Use Indirect option in session properties and give file_list name. In the file list you can have actual file names with complete path. Ex: In Session Properties SourceFileType --- Indirect and File Name xxx.txt. xxx.txt will contain all the input file names with complete path. like /home/.../...filename.dat /home/.../...filename1.dat
Loading Multiple Flat Files (INFORMATICA)
1.Creating a list file and Creating the list file:
You can create a list file manually and specify each source file you want to load into the target in a separate line. As an example consider the following list file:
Configure the following source file properties in the session for indirect source filetype:
Source File Directory: Enter the directory name where the source file resides. Source Filename: Enter the list file name in case of indirect load Source Filetype: Specify the indirect option when you want to load a multiple files with same properties.