| |
GeekInterview.com > Tech FAQs > DataStage
| Print | |
Question: Sparse Lookup and Normal Lookup
Answer: What are the differences between Sparse Lookup and Normal Lookup? |
| April 04, 2008 05:40:42 |
#1 |
| nagoosk |
Database Expert Member Since: November 2007 Total Comments: 13 |
RE: Sparse Lookup and Normal Lookup
|
Normal Lookup:In this when ever ds wants to look up it just place the target table data into buffer.
Sparse Lookup:To look up itr fires an sql query to the database instead of placing into buffer.To use sparse look up your target database must be larger than source table and your target should be a database of any type. |
| |
Back To Question | |
