What is update override?

Question Posted / guest

1 Answers
6835 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

my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers Mind Tree, Polaris,

Explain the tuning lookup transformation - informatica

0 Answers Informatica,

1)What is Data Masking in informatica? 2)How to restrict junk characters while loading data into target. 3) what happen if i won't pass sorted input in a transformation.

0 Answers

How can yoU improve session performance in aggregator transformation?

8 Answers TCS,

Which gives the more performance when compare to fixed width and delimited file ? and why?

3 Answers HP,

What is IQD file?

1 Answers

how you will maintain version?

3 Answers CTS, TCS,

What are the types of metadata that stores in repository?

2 Answers

Can we override a native sql query within informatica?