Informatica - Transformation to Load 5 Flat files

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 599 of 644

Transformation to Load 5 Flat files

What is the method of loading 5 flat files of having same structure to a single target and which transformations will you use?

Total Answers and Comments: 7

Last Update: January 08, 2009 Asked by: sarun5

Sponsored Links

Best Rated Answer

—

Submitted by: sarun5

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.

Above answer was rated as good by the following members:
karun_9, phdsong, ayappan.a, toSudharsan

February 19, 2008 16:13:08

Sreeya

Member Since: February 2008 Contribution: 3

RE: Transformation to Load 5 Flat files

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

Is this answer useful? Yes | No

1 1

Overall Rating: -N/A-

February 23, 2008 07:44:44

senthil_spy

Member Since: February 2008 Contribution: 1

RE: Transformation to Load 5 Flat files

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

Is this answer useful? Yes | No

February 25, 2008 23:56:47

krishrad

Member Since: December 2007 Contribution: 2

RE: Transformation to Load 5 Flat files

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.

Is this answer useful? Yes | No

March 02, 2008 11:18:47

gokulyadav

Member Since: March 2008 Contribution: 2

RE: Transformation to Load 5 Flat files

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.

Is this answer useful? Yes | No

March 12, 2008 20:21:13

sarun5

Member Since: February 2008 Contribution: 15

RE: Transformation to Load 5 Flat files

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.

Is this answer useful? Yes | No

3 0

Overall Rating: +3

May 08, 2008 14:57:51

franticsky

Member Since: May 2008 Contribution: 2

RE: Transformation to Load 5 Flat files

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

Is this answer useful? Yes | No

0 1

Overall Rating: -1

January 08, 2009 05:02:26

gaurav2485

Member Since: January 2009 Contribution: 12

RE: Transformation to Load 5 Flat files

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

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank