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 |
What are the issues you have faced in your project? How did you overcome those issues?
How to join three sources using joiner? Explain though mapping flow.
how eliminate the duplicates in flat file with out using sorter ,aggregater
What are the different tools in workflow manager?
What are the new features of informatica 9.x in developer level?
How to update source definition?
what are presession,postsession success and postsession failure commands ?
How do you implement unconn. Stored proc. In a mapping?
What happens if the info. Server doesn't find the session parameter in the parameter file?
when will we use unconnected & connected lookup? How it will effect on the performance of mapping?
what is scd?
What is aggregator transformation in informatica?