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 Posted / 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 |
Post New Answer View All Answers
What are some examples of informatica etl programs?
What does cheating measurement mean?
What are the different transaction levels available in transaction control transformation?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What are the uses of etl tools?
What are the components of workflow manager?
Which is the t/r that builts only single cache memory?
What is powercenter on grid?
What is rank transformation in informatica
3.how will u get information about bugs how will u rectify the bugs in realtime whch tool we are using to rectify the bugs
What are the different clients of powercenter?
Explain direct and indirect flat file loading (source file type) - informatica
What is sq transformation?
How to configure mapping in informatica?
What will be the approach?