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
- 8562 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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
list out all the transformations which use cache?
What is the difference between a repository server and a powerhouse?
Write the unconnected lookup syntax?
What are the types of caches in lookup? Explain them.
What is a grid in Informatica?
Explain target update override in informatica
How do you promote a non-reusable transformation to reusable transformation?
Mention few power centre client applications with their basic purpose?
What is the different lookup cache(s)?
Explian the Process of deployment groups in informatica
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
What is a dimensional model?
