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
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,
Explain pmcmd command usage in informatica
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
How do you load alternate records into different tables through mapping flow?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How can we handle two sessions in informatica?
How are the sources and targets definitions imported in informatica designer?
How many numbers of sessions can one group in batches?
-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?
Is there any target staging area in informatica not staging area
Briefly define a session task?
Differentiate between Load Manager and DTM?
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. ?
What do you mean by blocking transformation?
What are the tasks that source qualifier perform?