When will you use SQL override in a lookup transformation?
Answer Posted / vanita
For filtering the data in lookup table using where clause, or joing multiple tables to select data or to change the default order by clause with your own order by clause
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are the databases that informatica can connect to windows?
How we can create indexes after completing the load process?
how we can load rejected record's at run time?(not through bad files)
What are the new features of informatica 9.x at the developer level?
can we override a native sql query within informatica? How do we do it?
How do you load only null records into target? Explain through mapping flow.
what is the -ve test case in your project.
What are the main issues while working with flat files as source and as targets ?
What is decode in informatica?
Can one use mapping parameter or variables created in one mapping into any other reusable transformation?
What are the designer tools for creating transformations?
Separate from a database, an information bazaar, and an information stockroom?
Write the different tools in the workflow manager?
What is deployment group?
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab