if we take 2 tables(like emp and dept), we use join stage and
how to improve the performance?
Answer Posted / ashok
above answer has one mistake
i.e join doesn't has sort operation bydefault we explicitly
specify
Is This Answer Correct ? | 9 Yes | 3 No |
Post New Answer View All Answers
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 the use of datastage director?
What is the project in datastage?
Distinguish between informatica & datastage. Which one would you choose and why?
how to get sum of sal based on dept_no and then sum of all sal irrespective of dept_no in same sql. output:- 10, 200(sum of sal for dept_no 10), 5000(sum of all sal)
What is merge stage?
if we using two sources having same meta data and how to check the data in two sources is same or not? and if the data is not same i want to abort the job ?how we can do this?
what are the errors,warnings in datastage
Describe the main features of datastage?
What are the primary usages of datastage tool?
What is a datastage job?
Which commands are used to import and export the datastage jobs?
how to use self join using datastage ? can u tell me using stage how can we implemnet the self join
What are orabulk and bcp stages?
Is possible to create skid in dim,fact tables?