What is target update override
- 2 Answers
- 6557 Views
- CTS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ash
By Default the intergration service updates the target
based on key columns. But we might want to update non-key
columns also,at that point of time we can override the
UPDATE statement for each target in the mapping.The target
override affects only when the source rows are marked as
update by an update strategy in the mapping.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / usha
target update override which is used to update the data
with out using UPDATE transformation....
if there is no PK in the target we can update by using
target update override
| Is This Answer Correct ? | 1 Yes | 0 No |
What is metadata reporter?
What is the different lookup cache(s)?
followin source like region sales 1 100 2 200 i want the output following format region 1 2 sales 100 200
What are the reusable transforamtions?
What is dimensional table?
In dept 10, 5 emp sal, i want to do sum of dept 10 emp sal. Is there any othere transformation than the aggrator? if yes how?
what is the difference between Informatica 7.1 and Abinitio?
Tell me how many tables used in Ur project and how many fact tables and dimension tables used in ur project
Can i create a lookup table without cache.
Why do you use Mapping Parameter and mapping variable?
What is Index Caches size?
difference between source based commit? and target based commit? which is better with respect to performance?
Teradata 
