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 / 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 |
how i will stop my workflow after 10 errors
What are the circumstances that infromatica server results an unreciverable session?
how eliminate the duplicates in flat file with out using sorter ,aggregater
How we can get unique records into one target table and duplicate records into another target table??
11 Answers Deloitte, IBM, iGate,
I am using mapping variable, when i am running a session,before it has 10000 records, after completion of session what about value of mapping variable?
What is union transformation in informatica?
What is operational data source (ODS)?
how to use incremental load?
How to go to the older version for a mapping?
What is constraint based loading exatly? And how to do this? I think it is when we have primary key-foreign key relation ship. Is it correct? please answer me. Advance Thanks.
On which transformations you created partitions in your project?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?