What is the optimum method to load five flat files with same structures into target? What is meant by file repository?

If the structure is same, we dont need to import flat files 5 times,Instead we can use one flat files 5 times(just copy n past)..and then at session level we can give path and names for different flat files.

File repository is a collection of files with source file type as Indirect.

Just open a empty not pad and give the paths of files like

1.c:Flatfilesemp.txt

2.d:Flatfilesemp2.txt

3.g:Flatfilesemp3.txt

u can give any numbers.

Be carefull when u set the session properties "set source file type as Indirect."

bye

By using Union Transformation we can do that........

here we have to follow the steps
1. import the flat file into flat file dir i.e source analyser
2. create the target by drag and drop the source flat file because all with same structure.
3. Mapping drag the source file and target into the mapping analyser and then map the columns from source qualifier to target. and save the mapping.
Here is the main step have to perform
--------------------------------------------------
-->create a text file which is having the paths of the all flat files and save the file.
-->create session with the mapping created above. and double click the session, go to the properties tab give thetext file path which is having all paths of sources in the property SOURCEPATHFILE/PATH FILE.
-->as usual mapping tab give the source file path and target file path and file name.
-->create work flow and save and run.

 with that have to set the  session properties set source file type as "Indirect"

Step 1: Transfer all the 5 files on to your UNIX box or server from where you will fetch those 5 files

Step 2: open notepad and type the 5 files name .ex:- a.csv
b.csv
c.csv
d.csv
e.csv
step 3:save the file as five.txt

step 4:place this five.txt file on to the unix box

step 5:now in session level select INDIRECT option for flat file

step6:Type the name five.txt on the file name in session level

step 7:Refresh and run the session.

Set source file type as INDIRECT