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

Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?

621

What is the difference between a connected look up and unconnected lookup?

565

What are the different clients of powercenter?

591

-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?

4959

What is the sql query overwrite in source qualifier in informatica

611

Can you generate sequence numbers without using the sequence generator transformation?

593

generate date / time dimension in informatica

711

can anyone suggest best free Talend data integration training online

1248

Why sorter is an active transformation?

740

Quickly characterize reusable change?

683

What is the different lookup cache(s)?

605

What is DR strategy for Informatica project?

690

Explain what are the different versions of informatica?

651

Can we create a node as a gateway node and the same node can be assigned to a grid?

633

What all are steps in up gradation of Informatica server?

614