Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 3 Answers
- 8683 Views
- TCS, I also Faced
- E-Mail Answers
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
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How do you load only null records into target? Explain through mapping flow.
Informatica Checkpoints
Define mapplet?
what are the deliverables?in your project?
What is a passive transformation?
What are the limitations of joiner transformation?
What are different types of transformations available in informatica?
Briefly explain the aggregator transformation?
What is a connected transformation?
Explain sessions and how many types of sessions are there?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
How to load the data from a flat file into the target where the source flat file name changes daily?
What is target designer and target load order?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
