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 / sp
This can be done by defining the target load plan in the developer. You can define two instance of the target and use the same SQ with Expression to load the last row to the second instance of the target. The second instance will be set to load at last in the load plan.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to load the data from people soft hrm to people soft erm using informatica?
scenario where i can use only concurrent execution of workflow.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
Differentiate between Load Manager and DTM?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
What are the informatica performance improvement tips
expain about the tune parameters?
Which transformation should we use to normalise the COBOL and relational sources?
What is the difference between stop and abort in informatica
Write the program through which the records can be updated?
What is the scenario which compels informatica server to reject files?
What is meant by lookup transformation?
Informatica Checkpoints
Clarify the aggregator change?
What is a code page?