Difference in the implementation of lookup and join
stages,in joining two tables?
- 7 Answers
- 14345 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / anburadh
one more point to add on MERGE and LOOKUP
Merge can not allow duplicate records whereas LOOKUP will allow or can control duplicates using OPTION"MULTIPLE ROWS ON THE LINK" which is in constraint TAB.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is the sortmerge collector?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
Is the value of staging variable stored temporarily or permanently?
What are the job parameters?
Enlist various types of routines in datastage.
Have you used Unstructured data?
i have a job with 3 possibiliies finish with ststus ok abbort warning how do you handle these 3 in job sequence? explain the situation where you have appiled scd in your project? chandu
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
what is the difference between == and eq in UNIX shell scripting?
if i have two tables table1 table2 1a 1a,b,c,d 1b 2a,b,c,d,e 1c 1d 2a 2b 2c 2d 2e how can i get data as same as in tables? how can i implement scd typ1 and type2 in both server and in parallel? field1 field2 field3 suresh , 10,324 , 355 , 1234 ram , 23,456 , 450 , 456 balu ,40,346,23 , 275, 5678 how to remove the duplicate rows,inthe fields?
how can we create rank using datastage?what is the meaning of rank?
I have a few records just I want to store data in to targets cycling way how?
How will you move hashed file from one location to another location?
Can you filter data in hashed file?
Why do we use exception activity in Datastage?
