After a load is done to my target table, I need to insert a
last row, which might be formed at some expression
transformation and brought to target. Do I have to have
separate mapping to be run after the 1st mapping? Or in a
single mapping how to achieve this?
Answer Posted / arun
Guess the questione was something different. Need is to add a footer record at the end of the target. This can be done with one mapping, have two pipelines.
1) TO load to target
2) To Load last record to target.
Change the target load plan, to make sure the last record pipeline runs last.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is a shortcut and copy in Informatica and how two are different with each other?
Briefly describe lookup transformation?
pmscmd startworkflow -sv
Which transformation should we use to normalise the COBOL and relational sources?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Explain Dataware house architecture .how data flow from intial to end?
How can we use mapping variables in informatica? Where do we use them?
How to join three sources using joiner?
What is different between the data warehouse and data mart?
Repository user profiles
Where are the source flat files kept before running the session?
What is meant by active and passive transformation?
Clarify the aggregator change?
What is the sequence generator transformation in informatica?
how to load rows into fact table in data warehouse