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
Define ds designer?
What is the purpose of pivot stage?
what is the use of materialized view?
Hi , Can anyone give few examples of scenarios and there corresponding design in datastage..i am new to this tool...confused in design while my manager asking to design the job.. Please post the URL if there..so i can go through it.. Thanks in advance...
What are the types of hashed files in data stage
Why do you need stage variables?
What are the different kinds of views available in a datastage director?
disign the complex job in u r project?(they are aksing only complex job design and then data flow...)
What are system variables and sequencers in datastage
im new to this tool im now at project plz tell me step by step process how to design plz help me i wnt to go with exp for job plz give me d proper design and explination
What is meta stage?
table actions available in oracle connector?
What are the types of containers in datastage?
What are the primary usages of datastage tool?
root tree will find which is server job and which is parallel job?