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
Can we create multiple integration service on single repository?
Explain what are the different types of transformation available in informatica.
What are the differences between joiner transformation and source qualifier transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is pmcmd command?
Enlist the advantages of informatica.
Is it possible to use a client with different version than that of its Informatica server?
What is persistent lookup cache?
What is the difference between writing a joiner query in ANSI style and THETA style?
What are the guidelines to be followed while using union transformation?
How to do the error handling of if ur source is flatfiles?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What is confirmed fact in dataware housing?
Describe expression transformation?
What is the benefit of session partitioning?