wht target override?wht advantages it has compare to target
update?
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
Parameter and variable differences
Which transformation is needed while using the Cobol sources as source definitions?
Define pmcmd command?
What is a stored procedure transformation?
What is the difference between informatica 7.0 and 8.0?
How can you differentiate between powercenter and power map?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
where to store informatica rejected data? How to extract the informatica rejected data?
What is DR strategy for Informatica project?
What are the differences between oltp and olap?
Briefly explain the aggregator transformation?
If informatica has its scheduler why using third party scheduler?
What are roles and groups and benefits of using them?
can u give example for factless fact table
How to Create a folder using pmrep command?