sudhakar_viswa

 Profile Answers by sudhakar_viswa 

• Dec 26th, 2007

 

Hi,

   There is LookUp stage which does the lookup. Apart from this you can use Merge and Join Stages to do LookUp.

Regards,
-- sudhakar

srikanth2097

 Profile Answers by srikanth2097 

• Jan 3rd, 2008

 

for lookup two options available.. 1. lookup 2 sparsh lookup..
lookup is used when primary data is bulk..
sparsh is used when reference data is bulk..

Amritendra kumar

 Profile Answers by Amritendra kumar 

• Feb 21st, 2008

 

By lookup stage we can perform lookup by 2 ways
1. lookup: It is used when the reference table or file contain less data.
2. Sparce lookup: It is used when the main table is small and reference table is big.

Thanks

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Sep 19th, 2009

 

In DS 7.5 we have 2 types of lookup options are avilable: 1. Normal 2. Sparce

In DS 8.0.1 we have 3 types of lookup options are available 1. Normal 2. Sparce 3. Range

Range lookup: this will help you to search records based on perticular range. it will serch only that perticuler range records and provides good performance insted of serching the enire record set.

Regards,
Veeru.