What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
Answer Posted / rajkumar bachu
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.
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 Correct ? | 39 Yes | 0 No |
Post New Answer View All Answers
If informatica has its scheduler why using third party scheduler?
How you can differentiate between connected lookup and unconnected lookup?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
How to elaborate powercenter integration service?
Make a note of the quantity vaults made in informatica?
What is the sql query overwrite in source qualifier in informatica
Write the prerequisite tasks to achieve the session partition?
Which transformation should we use to normalise the COBOL and relational sources?
What is meant by pre and post session shell command?
What differs when we choose the sorted input for aggregator transformation?
What are the types of lookup transformation?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What is workflow monitor?
What is mapping debugger?