Sreeya

 Profile Answers by Sreeya 

• Feb 19th, 2008

 

We can use the Union Transformation to carry out the above functionality.

senthil_spy

 Profile Answers by senthil_spy 

• Feb 23rd, 2008

 

wat you have to do is
* create one more file in the same folder where u have those 5 files..and
* specify the path of all those 5 files...now just
*  take the metadata of any one file among those 5..as a source...
* but to give the connection information of the flat file u have to give the location of the 6th file(which contains the path of other 5).


correct me if am wrong...

krishrad

 Profile Answers by krishrad 

• Feb 25th, 2008

 

slight change in your answer.

U just give the names of those files(5 files) in a single file and give that file name.Also in a session properties change file type to "Indirect".

I think this explanation will clear your doubts.

gokulyadav

 Profile Answers by gokulyadav 

• Mar 2nd, 2008

 

Senthil
I have Tried with what you said but it is not loading into the target can you be clear with the attribute values for @ Source File Directory@ Source File Name@ Source File TypeTax.,

sarun5

 Profile Answers by sarun5 Questions by sarun5

• Mar 12th, 2008

 

Guys I have got the answer for which I asked..here you go

This can be handled by using the file list in informatica. If we have 5 files
in different locations on the server and we need to load in to single target
table. In session properties we need to change the file type as Indirect.
(Direct if the source file contains the source data. Choose Indirect if the
source file contains a list of files.
When you select Indirect, the PowerCenter Server finds the file list then reads
each listed file when it executes the session.)
am taking a notepad and giving following paths and file
names in this notepad and saving this notepad as
emp_source.txt in the directory /ftp_data/webrep/

/ftp_data/webrep/SrcFiles/abc.txt
/ftp_data/webrep/bcd.txt
/ftp_data/webrep/srcfilesforsessions/xyz.txt
/ftp_data/webrep/SrcFiles/uvw.txt
/ftp_data/webrep/pqr.txt

In session properties i give /ftp_data/webrep/ in the
directory path and file name as emp_source.txt and file type as Indirect.

franticsky

 Profile Answers by franticsky 

• May 8th, 2008

 

you have to use joiner to join the files and then load the target

gaurav2485

 Profile Answers by gaurav2485 

• Jan 8th, 2009

 

Plus we can use 5 pass through PARTITIONS as 5 files will be read concurrently

roshan239

 Profile Answers by roshan239 

• Jul 19th, 2010

 

This very easy to load more than one flat files to target. To do this we can save d full path name in a text file; there after in session properties write the full path name of the folder where we have copied all the full path names of the files and select the file type as INDIRECT. This is mechanism to load flat file from more than one flat file..

Hope you got your answer. 

nagadurgaraju

 Profile Answers by nagadurgaraju Questions by nagadurgaraju

• Sep 4th, 2010

 

Two Methods.

1. Write all files in one directory then use file repository concept (dont
forget to type source file type as indirect in the session).
2. Use union t/r to combine multiple input files into a single target.

Ashok Gulagond

• Dec 16th, 2016

 

When we have the same structured flat files, why don't simply use UNION make them a single file and then load to target instead of such complication? or UNION doesn't work on flat files?

Anurag

• Nov 27th, 2017

 

You should use a indirect file (which contain path and name of all the 5 files) as source. Transformation depends on the business logic.