Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between lookup and sparse lookup?
- 1 Answers
- 6831 Views
- I also Faced
- E-Mail Answers
Normal lookup will provide data for an in-memory look up
whereas Sparse lookup will access the database directly.
Normal might provide poor performance when the reference
data is huge as it has to load large data into memory.
In such scenarios a join stage may work better(It will put
the data onto an internal dataset file for each link,
and then do the join based on the data provided). If your
stream/source data is small then a sparse lookup is
suggested
as a row is retrieved from the database for each input row
instead of the full reference data being brought into
memory.
Sparse lookup sends individual SQL statement for every
incoming row (If stream/source data is huge you can imagine
the number
of times it has to hit DB and hence the down side on
performance). It can be used when you want to get the next
sequence
number from your database (Again expensive overhead on your
job as noted before). Also note that sparse lookup is only
available for DB2 and Oracle. Normal Lookup stage can have
multiple reference link but Sparse can only have one
reference
link. When normal is used it is a good practice to choose
less volume data as reference data.
| Is This Answer Correct ? | 15 Yes | 1 No |
What is use Array size in datastage
what is the diff b/w switch and filter stage in datastage
How much data u can get every day? 2)which data ur project contains? 3) what is the source in ur project?what is the biggest table & size in ur schema or in ur project?
What are the main differences you have observed between 7.x and 8.x version of datastage?
Terminate Activity
at source level i have 40 columns,i want only 20 cols at target what r the various ways to get it
In one project how many shared containers are created?
Why do we use exception activity in Datastage?
my soure table is emp having columns sal,deptno in the deptno 10,20,30deptno row are there expected out put is min(sal) of 10th deptno,max(sal) of 20th deptno,mean(sal) of 30th deptno using aggregation stage
Lookup constraints
What is difference between join, merge and lookup stage?
How will you move hashed file from one location to another location?
Teradata 
