if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
Answer Posted / rajeshchunduri
in emp and dept tables key column is deptno so it is key
based and datatype for key column is int . At this time we
change partion tech from hash to modulus.
chunduri
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What are some prerequisites for datastage?
Is the value of staging variable stored temporarily or permanently?
how to delete one row in target dataset
Describe routines in datastage? Enlist various types of routines.
what is the custome stage in datastage? how can we impliment that one? plz tell me
Could anyone give brief explanation bout datastage admin
Can you explain link buffering?
Why we use surrogate key?
How do u convert the columns to rows in datastage?
Differentiate between odbc and drs stage?
What are stage variables and constants?
What are the types of containers in datastage?
what are .ctl(control files) files ? how the dataset stage have better performance by this files?
What are stage variables?
What is the use of datastage director?