What is update override?

Question Posted / guest

1 Answers
6865 Views
Accenture, I also Faced
E-Mail Answers

What is update override?..

Answer / abhinav

Update Override is an option in Informatica at the session
level. In this, you can manually enter the SQL query to be
used. This query will be issued to the Database when the
session is run, overriding the SQL query generated by that
particular transformation at the mapping level.

Is This Answer Correct ?

9 Yes

0 No

Post New Answer

More Informatica Interview Questions

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers HP,

I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers IBM,

How might one distinguish in the case of mapping is right or not without associating session?

0 Answers

If we set dd_insert in mapping and Delete in session properties what will happen.?

4 Answers IBM,

Can we create two repositories on same database instance in oracle?

0 Answers

Hi, Steps for upgrading from informatica 7x to 9x or the link which will help me to upgrade from informatica 7 to 9. Regards, Eva

1 Answers Accenture,

What is the Process to creating lookup transformation in informatica

0 Answers Informatica,

how tokens will generate?