What is sql query override? When did u use sql query override?



What is sql query override? When did u use sql query override?..

Answer / santhosh

sql override is used to write sql select statements
sql override contains in source qualifier transformation

we can use sql override when the source and target are
homogenious database
it will not support flatfiles and hedrogenious database

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More Informatica Interview Questions

explain different types of modeling.

2 Answers  


What is the difference between informatica 7.0 and 8.0?

0 Answers  


What is informatica? Why do we need it?

0 Answers  


After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?

3 Answers   TCS,


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,


how to identify new and old values in source qualifier or any other transformations using informatica

2 Answers  


when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  


Major difference between SQL override and Lookup Sql override

1 Answers  


Define update strategy?

0 Answers  


What is domain and gateway node?

0 Answers  


what is incremental loading ?

12 Answers   CTS, IBM, Oracle, TCS,


Comment on significance of oracle 9i in informatica when compared to oracle 8 or 8i?

1 Answers  


Categories