Identify Normal and Sparse Lookup Datastage Job

By seeing a Datastage job how you will identify which one is Normal lookup and which one is Sparse Lookup?

Questions by Aloka   answers by Aloka

Showing Answers 1 - 4 of 4 Answers


  • 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

  Was this answer useful?  Yes


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

  Was this answer useful?  Yes


  • 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

  Was this answer useful?  Yes


  • 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions