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

How to join three sources using joiner? Explain though mapping flow.

694


How can we create index after completion of load process?

594


If informatica has its scheduler why using third party scheduler?

774


How to create the source and target database connections in server manager?

622


Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?

629






Whats there in global repository

1263


What is union transformation?

570


Define enterprise data warehousing?

632


How to generate sequence numbers?

616


Define sessions in informatica etl?

613


can anyone suggest best free Talend data integration training online

1255


What is a predefined event?

656


what is index?how it can work in informatica

1579


What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

785


How does a sorter cache works?

563