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


Please Help Members By Posting Answers For Below Questions

Can we create multiple integration service on single repository?

711


Explain what are the different types of transformation available in informatica.

581


What are the differences between joiner transformation and source qualifier transformation?

636


Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?

7778


What is pmcmd command?

685






Enlist the advantages of informatica.

640


Is it possible to use a client with different version than that of its Informatica server?

655


What is persistent lookup cache?

613


What is the difference between writing a joiner query in ANSI style and THETA style?

1931


What are the guidelines to be followed while using union transformation?

648


How to do the error handling of if ur source is flatfiles?

1519


what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?

1633


What is confirmed fact in dataware housing?

5705


Describe expression transformation?

640


What is the benefit of session partitioning?

610