i have a source of n records.i have to load n+5 records to my
target.What is the procedure??????plz tell me.....
Answer / srikanth
try below mapping in mapping designer
source->sourcequalifier->exptf1->trg( for n records)
->exptf2(with
sequencegtf)->routertf(sequence column=1 AND
5)->trginstance(same above trg)
Finally you will get total n+5 records into target. Here i
used only one target. just i taken instance.
It will work..
| Is This Answer Correct ? | 1 Yes | 0 No |
What do you understand by term role-playing dimension?
How do you migrate data from one environment to another?
enterprise datawarehouse your project phase by phase explain?
what is workflow varible
What all are steps in up gradation of Informatica server?
What is informatica metadata and where is it stored?
What is degenerated dimention table?
What is aggregate cache in aggregator transforamtion?
what is the difference between Informatica 7.1 and Abinitio?
hi guys..iam a QA person ..what is ETL TESTING... what is the process of ETL testing... ETLTESTER needs etl devolopment knowledge or not? pls suggest ur valuable decision
what is procedure to use mapping variable in source qualifier transformation? with example
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?