wht target override?wht advantages it has compare to target
update?
- 2 Answers
- 13051 Views
- Polaris, I also Faced
- E-Mail Answers
Answer Posted / siva
Target Update (by using Update strategy) will work only
when we have the Primary key in Target. Update override
will happen based on this key.If we don't have the Pkey
Update override will not work.
To overcome the above issue..If our Target is not having
any key column or if we want to update the Target based on
a column other than PKey column then we need to go for
Target Update override option available in Target
properties.
| Is This Answer Correct ? | 8 Yes | 1 No |
Post New Answer View All Answers
Different qualification between a related rotate toward the sky and isolates look upward?
How do you update the records with or without using update strategy?
what is the Default Source Option For Update Strategy Transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
scenario where i can use only concurrent execution of workflow.
Define the various join types of joiner transformation?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
What do you mean by channel change?
What is the difference between informatics 7x and 8x and what is latest version?
What is primary and backup node?
How many ways are there to create ports?
What is a dimensional model?
How do you load unique records into one target table and duplicate records into a different target table?
What is update strategy transform?
Define sessions in informatica etl?
