which memory is used by lookup and join
- 5 Answers
- 11129 Views
- IBM, I also Faced
- E-Mail Answers
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 |
what is combinability and non combinability?
How do y read Sequential file from job control?
what is the use of DSattchJob?DetachJob? where can we find it?
If you want to use a same piece of code in different jobs, how will you achieve this?
create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid salary previoussalary 10 1000 null 20 2000 1000 30 3000 2000 40 4000 3000
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
when will you go for dataset and fileset?
5) A file contains 10 (1-10) I want trgt like Trgt 1 trgt 2 trgt 3 1 2 3 4 5 6 7 8 9 10
Name the different sorting methods in datastage.
Can we use target hash file as a lookup ?
How do you import and export data into datastage?
How do you start developing a datastage project?
Teradata 
