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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different ways to implement parallel processing in informatica?

1097


What is InformaticaPowerCenter?

889


What are the restrictions of union transformation?

779


Explain why we use partitioning the session in informatica?

798


How to implement security measures using repository manager?

813


Differentiate between joiner and lookup transformation?

842


What are the static cache and dynamic cache in informatica?

952


What is domain and gateway node?

921


What does role playing dimension mean?

796


What is an Integration service in Informatica?

893


Plz can any one say me how to get the informatica certification materials and dumps

1804


What are the validations that you can perform in oracle and in informatica ? Advance Thanks

1853


What is native users?

902


How can we use mapping variables in informatica?

781


What is dynamic cache?

782