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 we can load rejected record's at run time?(not through bad files)
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What is a joiner transformation and why it is an active one?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
What are the differences between source qualifier and joiner transformation?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How to Create a folder using pmrep command?
What is an unconnected transformation?
What do you mean by filter transformation?
How does a sorter cache works?
Which is the t/r that builts only single cache memory?
What is workflow manager?
How do you load first and last records into target table?
What are multi-group transformations?