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
- 8736 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
difference between repository database and repository service?
What are the prerequisite tasks to achieve the session partition?
in reporting we add some new objects,how we get the count of the newly added objects to the report
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
What is the difference between writing a joiner query in ANSI style and THETA style?
Explain joiner transformation in informatica
How would you copy the content of one repository to another repository?
What are the transformations that are not supported in mapplet?
Clarify the utilization of aggregator cache record?
How to generate sequence numbers using expression transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
can we override a native sql query within informatica? Where do we do it? How do we do it?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is aggregator transformation in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
