which memory is used by lookup and join

Categories >> Software >> Data Warehouse >> Data Stage
Suggest New Category

Question Posted / vijayp.dw

5 Answers
12918 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

which memory is used by lookup and join..

Answer / kala

Join use the buffer memory and Lookup use the physical memory(RAM)

Is This Answer Correct ?

14 Yes

1 No

which memory is used by lookup and join..

Answer / kiran

Lookup runing based on RAM

Is This Answer Correct ?

8 Yes

2 No

which memory is used by lookup and join..

Answer / subbuchamala

-->LOOK-UP runs based on physical memory(RAM).

While doing Look-Up, Data will be loaded into the Physical Memory(RAM) which faster and better for LOW Valume of data.

-->JOIN Uses the Buffer Memory(disc memory)

Buffer Memory(disc memory)--> this path is specified in the Configuration file and parameter name is: SCRATCH DISK path

Is This Answer Correct ?

3 Yes

0 No

which memory is used by lookup and join..

Answer / raam chowdary

join is used in permanent memory and lookup is used in buffer(ram)

Is This Answer Correct ?

4 Yes

2 No

which memory is used by lookup and join..

Answer / naren

join is use the disc memory,look up use the buffer memory(ram)

Is This Answer Correct ?

2 Yes

2 No

Post New Answer