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
No Answer is Posted For this Question
Be the First to Post Answer
How to move data set from one server to other?what are the steps to follow to do this?
What can we do with datastage director?
Unix Qn asked in datastage interview: I have diff type(.txt, .tmp, .bat etc) of file in 4 diff directories, I want move all '.txt' file from 4 directories to other folder. And need to delete all the files except which are created TODAY?
for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr
tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?
How we can convert rows to columns in datastage?
what is usage of datastage with materialized views
how to call routines in stages?
hi, 1)totally how many jobs created in ur project 2)what is ur datamart size & Dwh size 3)How secure ur project 4)could u plz tell be about testing process after complete the job will run sucessfully or not in Datastage
What are the third party tools you used in your project?
How to Convert a string function to date function by using only sequential file stage with out using other stages ?
Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?