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 difference between complete, stop and abort?
How can you validate all mappings in the repository simultaneously?
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
What all are steps in up gradation of Informatica server?
Differentiate between joiner and lookup transformation?
How to create or import flat file definition in to the warehouse designer?
What are the features of complex mapping?
explain one complex mapping with logic? sales project?
What is a filter transformation and why it is an active one?
What is workflow monitor?
While migrating the data from one environment to another environment how would you manage the connections?
Does an informatica transformation support only aggregate expressions?
What are the different versions of informatica?
What is source qualifier transformation in informatica?