Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 24789 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 |
i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no
what is constraint based load order
which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?
If no. of source columns is changing every time (First time it is 10 next time it is 20 so on). How to deal with it without changing mapping?
how to load only the first and last record of a flat file into the target?
How to open an older version of an object in the workspace?
wt is the difference between truncate and delete in which situation u use delete and truncate in real time..
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
my source is junk data how will u remove that junk data by using unix please any one replay me
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
I have source like this year account month amount ----- --------- ------ -------- 1999 salaries jan 9600 1999 salaries feb 2000 1999 salaries mar 2500 2001 benfits jan 3000 2001 benfits feb 3500 2001 benfits mar 4000 -->i need target like this year account month1 month2 month3 ----- --------- -------- -------- -------- 1999 salaries 9600 2000 2500 2001 benfits 3000 3500 4000
performance tuning of Informatica
Teradata 
