Interested to Buy Any Domain ? << Click Here >> for more details...
if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
- 5 Answers
- 15676 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What is a ds designer?
What is the difference between server job and parallel jobs?
How complex jobs are implemented in datstage to improve performance?
How do you schedule or monitoring the job?
How to read the length of word in unix?
Can you implement SCD2 using join, transformer and funnel stage?
i WANTED TO USE THE RANGE LOOKUP SCENARIO IN DATASTAGE 7.5.2 SRVER JOB.i HAVE A DATE FIELD IN SOURCE AND I SHOULD MATCH IT WITH A FIELD IN LOOKUP FILE.BUT,THE FIELDS SHOULD MATCH EVEN THOUGH THERE IS SOME RANGE.CAN SOMEONE TELL ME HOW CAN I DO THAT. THANKS
how to write server Routine coding?
Difference between ‘validated ok’ and ‘compiled’ in data stage?
Explain the situation where you have applied SCD in your project?
what is stage is used for below Input columns: dept|mgr|employee|salary Output columns: mgr|count of employee per mgr|avg salary per dept note: each dept has one mgr and each mgr has many employees
what is use of SDR function?
Does datastage support slowly changing dimensions ?
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
Differentiate between validated and Compiled in the Datastage?
