vijay

• Dec 20th, 2006

 

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.

Sravan Kumar

• Dec 20th, 2006

 

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

ngreddy

 Profile Answers by ngreddy 

• Mar 17th, 2011

 

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

pavankumar_greek

 Profile Answers by pavankumar_greek 

• Mar 31st, 2011

 

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 the text 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.

pavankumar_greek

 Profile Answers by pavankumar_greek 

• Mar 31st, 2011

 

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

Amit Gaikwad

• Jul 26th, 2012

 

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.

Naveen

• Nov 8th, 2012

 

Set source file type as INDIRECT