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 631

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

Total Answers and Comments: 3

Last Update: December 06, 2007 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

Go To Top