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 / 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 |
Post New Answer View All Answers
What is the session task and command task?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
How many number of sessions can one group in batches?
What do you mean by channel change?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
what is the -ve test case in your project.
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
What is substr in informatica?
How many transformations can be used in mapplets.
what is the size of u r source(like file or table)?
What is dimensional table? Explain the different dimensions.
How to create the source and target database connections in server manager?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
What is the difference between source qualifier transformations source filter to filter transformation?