which memory is used by lookup and join
Answers were Sorted based on User's Feedback
Answer / kala
Join use the buffer memory and Lookup use the physical memory(RAM)
| Is This Answer Correct ? | 14 Yes | 1 No |
-->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 |
Answer / raam chowdary
join is used in permanent memory and lookup is used in buffer(ram)
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / naren
join is use the disc memory,look up use the buffer memory(ram)
| Is This Answer Correct ? | 2 Yes | 2 No |
On which interface you will be working as a developer?
What are the types of containers?
How do u set a default value to a column if the column value is NULL?
Can you explain engine tier in information server?
How do you reject records in a transformer?
how to design the change capture stage in(data stage parallel jobs) type 2
Why fact table is in normal form?
Can you explain tagbatch restructure operator?
1.what is materialized data? 2.how to view the materialized data?
what is the custome stage in datastage? how can we impliment that one? plz tell me
Hi, I am getting data from sequential file like below column1 A&B C&D A&E X&Y&Z v&x But I need the target column as like below column1 A and B C and D A and E X and Y and Z v and x
If the job aborted in a sequencer, how can we start that from the previews successful job.