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
How to join three sources using joiner?
How to do unit testing in informatica? How to load data in informatica ?
What are roles and groups and benefits of using them?
Define the various join types of joiner transformation?
is it possible to index the data in cache of lkp transformation ?
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
how to create user defined function (udf) in informatica
What are the designer tools for creating transformations?
What is the different lookup cache(s)?
What is a router transformation?
What is the surrogate key?
What is meant by query override?
where to store informatica rejected data?
What is the meaning of up gradation of repository?
What is meant by a domain?