Informatica - why do we need lookup sql override? Do we write sql override in lookup with special aim?

GeekInterview.com > Interview Questions > Data Warehousing > Informatica

Go To First | Previous Question | Next Question

Informatica | Question 581 of 644

why do we need lookup sql override? Do we write sql override in lookup with special aim?

Total Answers and Comments: 4

Last Update: November 04, 2009 Asked by: loosecontrol

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

November 13, 2007 23:47:42

vizaik

Member Since: March 2007 Contribution: 30

RE: why do we need lookup sql override? Do we write sq...

Yes sql override in lookup used to lookup more than one value from more than one table.

Is this answer useful? Yes | No

November 28, 2007 22:29:16

chandrarekha

Member Since: May 2007 Contribution: 14

RE: why do we need lookup sql override? Do we write sql override in lookup with special aim?

You can join the data from multiple tables in the same database by using lookup override

You can use sql override if

1. To use more than one look up in the mapping
2. You can use SQL override for filtering records in the cache to remove unwanted data

Is this answer useful? Yes | No

December 06, 2007 12:17:34

ask_kaushik

Member Since: December 2007 Contribution: 5

RE: why do we need lookup sql override? Do we write sql override in lookup with special aim?

Lookup override can be used to get some specific records(using filters in where clause) from the lookup table. Adavantages are that the whole table need not be looked up..

Is this answer useful? Yes | No

November 03, 2009 12:05:54

avneeshrathor

Member Since: November 2009 Contribution: 7

RE: why do we need lookup sql override? Do we write sql override in lookup with special aim?

For some special cases like for example You need to select the max salary
from emp table for a particular dept. then use

"select max(salary) from emp where deptno in_dept_no
group by deptno".

Kindly let me know if this is possible without using SQL override in lookup.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank