Interested to Buy Any Domain ? << Click Here >> for more details...
which memory is used by lookup and join
- 5 Answers
- 12654 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 |
col1 123 abc 234 def jkl 768 opq 567 789 but i want two targetss target1 contains only numeric values and target2 contains only alphabet values like trg1 123 234 768 567 789 trg2 abc def jkl opq
input like 2 7 8 9 5 1 7 3 6 output:2 5 6 how to find out this plz explain?
how can we create rank using datastage?what is the meaning of rank?
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
what is ds administrator used for?
pls ,tell me good Training centre with Job Oppertunity for Data stage in chennai?
Hi I am Vijay In my source i've 10 records in a single column.... but i want to split those records into 5 sequential files each seq file contains 2 records.?.... can any body help me?
15 Answers Scope International,
cust id,cust quty like 1,101;1,102;1,103 i want output like cust id,cust quty 1 101,102,103 in oracle please write a query in oracle
How many types of sorting methods are available in datastage?
how to implement scd2 in datastage 7.5 with lookup stage
What are the enhancements made in datastage 7.5 compare with 7.0?
Have you have ever worked in unix environment and why it is useful in datastage?
Teradata 
