WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
Answer Posted / vishnu_kr
Hi,
i guess the SQL override is used in the source qualifier trf
to implement joins, filter, sorter etc..
but update override is used in the Target table definition.
u use this option to update Targets that have no primary
key (hence u can't use update strategy) coupled
with 'Update as update' property in the session mappings tab
and 'Treat rows as' property set as 'Update' in the session
Properties tab.
Is This Answer Correct ? | 25 Yes | 3 No |
Post New Answer View All Answers
Define enterprise data warehousing?
What are multi-group transformations?
What does cheating measurement mean?
What is a joiner transformation?
What is a transaction control transformation?
explain abt ur project architecture?
How do we call shell scripts from informatica?
what is song in infrmatica...?
What are active and passive transformations?
Different sorts of metadata that stores in the storage facility?
How to create different types of slowly changing dimensions (SCD) in informatica using the mapping wizard?
What is meant by incremental aggregation?
How do you remove duplicate records in informatica? And how many ways are there to do it?
list out all the transformations which use cache?
have u done any performance tuning? how u ll do?