if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
Answer Posted / ashok
above answer has one mistake
i.e join doesn't has sort operation bydefault we explicitly
specify
| Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
What is "fatal error/rdbms code 3996" error?
What is difference between join, merge and lookup stage?
Terminate Activity
What is the purpose of pivot stage?
What are the different options associated with dsjob command?
explain about citrix scheduling tool in datastage
What is a quality stage in datastage tool?
On which Dimension Table you implemented SCD Type in your Project
what is the use of surogate key in datastage
Can you define merge?
Hi everyone,I have kept a project Sales And Distribution for a pharmaceutical company.can anybody explain one complex business rule that we had in our project and how did you accomplish it using DS?
Notification Activity
If you want to use the same piece of code in different jobs, how will you achieve it?
Difference between server jobs & parallel jobs?
Is possible to create skid in dim,fact tables?