1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE
AND UPDATE OVERRIDE ?

Question Posted / vishnu_kr

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


Please Help Members By Posting Answers For Below Questions

What is different between the data warehouse and data mart?

629

I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.

631

I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

598

What is workflow? What are the components of the workflow manager?

637

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

692




what is the size of your data warehousing?

1669

How to generate or load values in to the target table based on a column value using informatica etl tool.

606

During the running session, output files are created by informatica server. Enlist few of them.

538

where to store informatica rejected data? How to extract the informatica rejected data?

598

Define pmcmd command?

618

Can anyone tell me the new features in Informatica 9 Version?

1529

Target increases every day even though no new record was inserted

1104

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,

6749

What is a grid in Informatica?

605

what are the Methods For Creating Reusable Transformations?

647