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 connected or unconnected transformations?

1119

What are batches?

1096

What is meant by query override?

1057

explain about unit testing? in real time?

2198

Is it possible to revert a global repository to local one and why?

1080

what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?

2322

if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2197

What is a mapplet/worklet in informatica?

1185

What is meant by lookup transformation?

1101

What are some examples of informatica etl programs?

940

What is workflow manager?

1044

Which transformation should we use to normalise the COBOL and relational sources?

1203

How do you load alternate records into different tables through mapping flow?

1855

What is the meaning of decode in informatica?

1120

What is mapplet in informatica?

1056