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
How to Create a folder using pmrep command?
What are the static cache and dynamic cache in informatica?
Is it possible to use a client with different version than that of its Informatica server?
Implementation methodology
Repository user profiles
How do you convert single row from source into three rows into target?
Enlist the differences between database and data warehouse.
State the differences between sql override and lookup override?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is fact table? Explain the different kinds of facts.
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What is xml source qualifier transformation in informatica?
What is Session and Batches?
Explain what transformation and how many are there in informatica?