vibgyss

• Aug 24th, 2016

 

Normal lookup: lookup at memory that means when you design a job, The reference data is stored in the memory. Then primary data is going to compare with reference data in the memory.
In the primary link it shows how many rows are there on the primary source as well as in the reference link also it shows the rows details.

If primary link rows count = primary rows
And reference link rows details = reference file count then it is Normal lookup
Sparse Lookup: Lookup at source that means the reference data is going to store in primary link.
If primary link rows count = primary rows
And reference link rows details = primary rows then it is Sparse lookup

Lokesh

• Jan 27th, 2017

 

Normal lookup : All the data stores in virtual datasets and perform the lookup operations .
Sparse Lookup: it will directly deal with database.

Sri

• Mar 30th, 2017

 

It can be viewed when you open the Oracle connector stage and where the lookup type is mentioned.
By default lookup type is normal

Ram

• May 23rd, 2017

 

Sparse look up can be used only for DB stages as Source and Target where as Normal can be used for both files as well as DB stages