Interested to Buy Any Domain ? << Click Here >> for more details...
what is sparse lookup?
- 7 Answers
- 31295 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ramya
use sparse lookup when reference database is huge i.e ratio
of input data and reference data is 1:100 or more
| Is This Answer Correct ? | 37 Yes | 7 No |
Answer / venugopal
When the reference data is more and source data is very
very less at that time we are using the Sparce lookup i.e
the ratio is 1:100
| Is This Answer Correct ? | 23 Yes | 5 No |
Answer / prasad
whenever the reference data is very huge than the primary
data then it will be problem for usig lookup stage,b'se the
data stored in buffer in lookup stage.using sparse lookup we
can perform the lookup in database level not in the
buffer,so the performance can be automatically improved...
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / chenna
sparse lookup has more memory so that if reference table
contains huge amount of data perfer to use sparse lookup
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / ananda
Join: When volume of data is more than 10 million in both
source and reference link.
Sparse Lookup: When reference data is > 500 million and
source data is <10 million.
| Is This Answer Correct ? | 2 Yes | 8 No |
Answer / vin
If reference data is huge then we will go for join stage.
Then when we will use join and sparce is useful?
| Is This Answer Correct ? | 1 Yes | 15 No |
IN SEQUENTIAL FILE,I HAVE DATA LIKE THIS EID,ENAME 11,AA 11,CC 22,DD 33,EE 22,AA 22,BB 22,CC 11,BB THEN i SELECT perform sort ON eid,uncheck both unique,stable AND I CHOOSE hash SORTING.WHAT IS THE OUTPUT I CAN GET.what happend if i select UNIQUE,STABLE. PLEASE EXPLAIN HOW THE RECORDS DISPLAY AT TARGET.
I have file with empid,empname and I want to load these two fields along with sal in my target 1)salary must be same for all the records 2)I want pass the salary at run time
what is advantages of snowflake when it is used?
Star Schema vs. Snow Flake Schema. What is the best model for DW? Give example for both the models performance wise?
what is snow flack schema?
we run a job in 4 nodes,i want to run same job on 8 nodes is it possible? job recompling is mandtory?why?
What is the difference between SQl Loader and OCI in datastage?
how will u design file watch jobs?
1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?
what is normalization and denormalization
what will happen if we allow duplicates in datastage lookup abort drop record 1st value of duplicate record none
In aggregator stage,to find the sum of the entire group of columns,it displays in binary format. How can i solve this problem.
Teradata 
