if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
Answer Posted / kiran
when ever join 2 tables based on key columns if the key
column is numeric ,set modulus,if the key column is non
numeric set hash partition technique.and compare to look up
join give better performance coz join has sort operation
by default.
Is This Answer Correct ? | 11 Yes | 2 No |
Post New Answer View All Answers
Is the value of staging variable stored temporarily or permanently?
options available in sequence job to run,validate?
what is flow of project?
What is the differentiate between data file and descriptor file?
Where do you see different stages in the designer?
How a source file is populated?
What are transforms and what is the differenece between routines and transforms?
Explain the situation where you have applied SCD in your project?
How a routine is called in datastage job?
which r the connectors used in san?
How do y read Sequential file from job control?
What are the types of containers in datastage?
How to reverse the string using unix?
Name the third party tools that can be used in datastage?
Can you explain link buffering?