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 is the difference between informatica6.1 and infomatica7.1
Where do we use mapping variables in informatica?
How does a sorter cache works?
Under what condition selecting sorted input in aggregator may fail the session?
Did u used latest transformations of 8.6.0? for what?
Describe data concatenation?
What will be the approach?
wat are deployement groups in informatica, how it will be used for developers
Differentiate between a database and data warehouse?
What is workflow? What are the components of workflow manager?
Explain pushdown optimization and types in informatica
What is union transformation in informatica?
Define Pmrep command?
Explain joiner transformation in informatica
What is informatica worklet?