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.
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.
