In which situations we can use normal and sparse lookup stages

In which situations we can use normal and sparse lookup
stages

Question Posted / hasinigam@gmail.com

4 Answers
14932 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In which situations we can use normal and sparse lookup stages..

Answer / nandini

Normal lookup:- U r having 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 temprovary memory.

Sparse lookup:-U r having 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 temprovary memory because
it s having the huge data.

Is This Answer Correct ?

17 Yes

0 No

In which situations we can use normal and sparse lookup stages..

Answer / poornachandrababu.l

When the reference is database then we will go for Sparse
look and If reference is Sequential file or DataSet then
we go for normal look up

Is This Answer Correct ?

6 Yes

5 No

In which situations we can use normal and sparse lookup stages..

Answer / 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

In which situations we can use normal and sparse lookup stages..

Answer / 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