WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?
- 7 Answers
- 33150 Views
- Target, I also Faced
- E-Mail Answers
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
What the difference is between a database, a data warehouse and a data mart?
Explain the types of lookup transformation?
Is there any target staging area in informatica not staging area
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
What is the use of target designer?
What is the difference between Active and Passive transformation?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
Design time, run time. If you don't create parameter what will happen
Tell me about Propagate functions in informatica
Mention some types of transformation?
How can we store previous session logs?
What is domain and gateway node?
What is xml source qualifier transformation in informatica?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
