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

Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,

6829


Explain pmcmd command usage in informatica

796


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

697


How do you load alternate records into different tables through mapping flow?

1416


What are the conditions needed to improve the performance of informatica aggregator transformation?

679






How can we handle two sessions in informatica?

691


How are the sources and targets definitions imported in informatica designer?

769


How many numbers of sessions can one group in batches?

695


-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

5139


Is there any target staging area in informatica not staging area

2229


Briefly define a session task?

674


Differentiate between Load Manager and DTM?

1759


How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?

1690


What do you mean by blocking transformation?

674


What are the tasks that source qualifier perform?

722