in emp and dept tables key column is deptno so it is key based and datatyp

if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?

Question Posted / rajeshchunduri

5 Answers
15454 Views
Cap Gemini, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What is ibm datastage flow designer?

1141

How many Key we can define in remove duplicate stage?

1373

What is datastage?

1078

Difference between server jobs & parallel jobs?

1071

What could be a data source system?

998

How to manage date conversion in Datastage?

1132

I/p : F1 table have A,B,C,D,E and F2 table having C,E,V i need output 0utput1: ABD output2: V any one suggest me this

1002

Can you explain kafka connector?

1303

What is "fatal error/rdbms code 3996" error?

1259

How to Remove Duplicate using SQL?

1357

Can we use target hash file as a lookup ?

3323

What is the project in datastage?

1106

Terminate Activity

1271

whom do you report?

1921

what is the difference between == and eq in UNIX shell scripting?

1495