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
- 22398 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 do you set a varible in incremental aggregation
i have n number of records in my source, i want first and last record to my target. how can u implement this scenario .
permutations of mapplet
What is rank transformation in informatica
How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?
What is repository manager?
As union transformation gives UNION ALL output, how you will get the UNION output?
hi all, I have to do Informatica Certification? Can any body send me Some Informatica Certification Dumps/FAQS ? Advance Thanks...
After draging the ports of three sources(sql server,oracle,informix) to a single source qualifier, can you map these three ports directly to target?
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
Can we combine a flatfile and a database table using an UNION transformation?
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
Teradata 
