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
- 22484 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 |
Explain how to import oracle sequence into informatica?
can you use flat file for lookup table?why?
why do we go for update strategy tr in SCD rather using the session properties?
How will you update the first four rows and insert next four rows in a mapping?
following scenario i have 1000 record flatfile source i want ist row to ist target 2nd eow to 2nd target 3rd row to 3rd target how will u do?
What are active transformations? Name them.
What is the procedure to load the fact table.Give in detail?
Explain the informatica workflow?
What are the uses of etl tools?
Diffrence between 7.1,8.1 and 8.6
What are set operators in Oracle
Without using any transformations how u can load the data into target?
Teradata 
