When will you use SQL override in a lookup transformation?

Question Posted / ram

1 Answers
5760 Views
I also Faced
E-Mail Answers

When will you use SQL override in a lookup transformation?..

Answer / 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

More Informatica Interview Questions

What is aggregate awareness?

1 Answers

How informatica recognizes mapping?

2 Answers CTS,

explain the scenario for bulk loading and the normal loading option in Informatica Work flow manager ???

8 Answers CTS, TCS,

111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers IBM,

How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?

2 Answers Rolta,

Could any one to tell How to use the Oracle Analytic functions in Informatica?

1 Answers

What is a stored procedure transformation?

0 Answers

HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION

0 Answers

how can we load starting with 11th record of a table from source to target

6 Answers IBM,

What is target update override

2 Answers CTS,

What is the use of target designer?

0 Answers

Clarify the utilization of aggregator cache record?

0 Answers

For more Informatica Interview Questions Click Here