In which situations we can use normal and sparse lookup
stages
Answer Posted / subbuchamala
Sparse LookUp:
for each source value, It will go refernce Database and get the Output.
Normal lookup:- 90% data in primary like(source
table) and 10% data of Refference link(lookup table)then we can use normal lookup.and the normal
lookup data uses in the temporary memory(RAM).
Sparse lookup:- 10% data in primary like(source
table) and 90% data of Refference link(lookup table)then we can use sparse lookup.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara
project Steps,hits, Project level HArd things,Solved methods?
Give an idea of system variables.
What are the different types of lookups in datastage?
To see hidden files in LINIX?
Can you explain link buffering?
What is apt_config in datastage?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
Name the command line functions to import and export the DS jobs?
what is flow of project?
EXPLAIN SCD
in oracle target stage when we use load option and when we use upsert option?
How we can covert server job to a parallel job?
How one source columns or rows to be loaded in to two different tables?
On which Dimension Table you implemented SCD Type in your Project