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
- 8558 Views
- TCS, I also Faced
- E-Mail Answers
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
I have a flat file, want to reverse the contents of the flat file
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
What are the reusable transformations?
How does a sorter cache works?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
Explain the shared cache and re-cache?
Name the different lookup cache(s)?
Partition, what happens if the specified key range is shorter and longer
What is meant by lookup transformation? Explain the types of lookup transformation?
What is the use of transformation?
Have you worked with/created Parameter file
generate date / time dimension in informatica
Which files are created during the session rums by informatics server?
What are the main features of Oracle 8i with context to datawarehouse?
How many dimensions are there in informatica?
