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
Explain the different kinds of facts.
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
which one is better performance wise joiner or look up
State the differences between sql override and lookup override?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What are the new features of informatica 9.x at the developer level?
Tell me about MD5 functions in informatica
Explain the code page compatibility?
What are Dimensional table?
Can we create two repositories on same database instance in oracle?
Could you explain what is enterprise data warehouse?
Can you use flat files in Mapplets.
What is dynamic cache?
Describe an informatica powercenter?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?