Interested to Buy Any Domain ? << Click Here >> for more details...
which memory is used by lookup and join
- 5 Answers
- 13067 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 |
How do you start developing a datastage project?
What is the roundrobin collector?
what is the function in Transformer stage can act as Rank function in Oracle
eno ename 1 qaz 1 wsx 1 edc 2 zxc 2 asd 3 qwe 3 wer 3 tru 4 rgj Output: eno ename count 1 qaz,wsx,edc 3 2 zxc,asd 2 3 qwe,wer,tru 3 4 rgj 1 I want the above output to be solved by DataStage as well and I have to write SQL query for the same output.
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 to sort two columns in single job in datastage.
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
What is ibm datastage?
How to delete the data in dataset?types of deleting the data in dataset?
how can we create tables in datastage?
hi iam new to this tooliam cmpltied to know abt datastage so now iam in project tell me whole step by step what iam doing iwnt to go with exp so plz hlp me pals
Hi all, explain one complex business rule that you had in your project and how did you accomplish it using DS?
Teradata 
