You can override the WHERE clause to include non-key columns by using tar

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

Question Posted / lokendra

Answer Posted / lokendra

You can override the WHERE clause to include non-key
columns by using target override

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2296

What is main use of mapplet?

1073

What are multi-group transformations?

1013

Which transformation is needed while using the Cobol sources as source definitions?

1128

What are the transformations that are not supported in mapplet?

959

Please let me know how to make Data masking in informatica..

1665

Explain about Informatica server process that how it works relates to mapping variables?

1010

Can we create a Integration service without a Repository service and vice versa?

1174

How do you load only null records into target? Explain through mapping flow.

1958

In development project what is the process to follow for an etl developer from day1

1652

how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

6914

Define sessions in informatica etl?

972

How to extract sap data using informatica? What is abap? What are idocs?

1092

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1729

What are the limitations of joiner transformation?

1049