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
Is there any way to read the ms excel datas directly into informatica?
Explain Dataware house architecture .how data flow from intial to end?
What are data-driven sessions?
What are the different ways to implement parallel processing in informatica?
How we can create indexes after completing the loan process?
Can informatica load heterogeneous targets from heterogeneous sources?
Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?
Explain sql transformation in script mode examples in informatica
Why update strategy and union transformations are active?
What happens when a session fails and you click on recover?
What is substr in informatica?
To import the flat file definition into the designer where should the flat file be placed?
What are the designer tools for creating transformations?
What is the difference between STOP and ABORT options in Workflow Monitor?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.