What is the method of loading 5 flat files of having same
structure to a single target and which transformations I can
use?
- 8 Answers
- 22453 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / deepu
To load 5 differnt files of same format .first creat a
directory in Unix and copy all the file into this directory
and using the option as Indirect load in session properties
give the loaction of unix in source and it will enable to
load all the 5 files in single run in to a target . if we
have 5 diff files in 5 different formats then firstly
convert all in to one format and then proceed as explained
aboue.
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / arnab
Use Union transformation , if you do not want to use Union
and if your informatica runs on Unix , then create a shell
script to concatenate these files and create a single
file , you can call this shell script before you call the
session in the workflow
If you use windows create and dos batch script and do the
same as above
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / dragon
I have a query, suppose i have 6 file in 3 different ftp
server with same file structure and i want to load data
using single mappping. In this case how can we use filelist.
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / ghk
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.
| Is This Answer Correct ? | 1 Yes | 3 No |
we can use Union Transformation to load multiple files into
single target.
| Is This Answer Correct ? | 4 Yes | 13 No |
How can one identify whether mapping is correct or not without connecting session?
Why use shortcuts(Instead of making copies).
To import the flat file definition into the designer where should the flat file be placed?
comonly how meny mappings r there in Banking projects?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
What is depict expression change?
hi i want to install latest informatica software in my pc..can anybody help me where should i get the infomatica software..plz help me
Explain sessions?
What is event and what are the tasks related to it?
insallation procedure for power center 8.1.1 especialy domain_config hw to use parameter files
how the informatica server sorts the strings values in rank transformations?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
Teradata 
