Interested to Buy Any Domain ? << Click Here >> for more details...
In which situations we can use normal and sparse lookup
stages
- 4 Answers
- 15941 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / subbuchamala
Normal lookup:-
If we have 90% data in primary like(source
table) and 10% data of Refference link(lookup table)in kind
of sutivation we can use normal lookup.and the normal
lookup data can stores in the temporary memory(RAM).
Sparse lookup:-
If we have 10% data in primary like(source
table) and 90% data of Refference link(lookup table)in kind
of sutivation we can use sparse lookup.and the sparse
lookup data can not stores in the temporary memory because
Refernce will have Huge data and for record(KEY Columns) from Source it will go to Reference Database and get the Output of it.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How many areas for files does datastage have?
What is the difference between in process and inter process?
why do u need the IOS upgradation in a FC switch
how to add a new records into source?
There are two file are there .1st file contains 5 records and 2nd file contain 10 records in target they want 50 records.how can achieve this
What are the types of hashed files in data stage
How do you start developing a datastage project?
Enlist various types of routines in datastage.
Can you explain how could anyone drop the index before loading the data in target in datastage?
Is possible to create skid in dim,fact tables?
How to convert RGB Value to Hexadecimal values in datastage?
I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this
What are the types of containers and how to create them?
Can anyone tell me a difficult situation who have handled while creating Datastage jobs?
How will you move hashed file from one location to another location?
