Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Post New Answer

More Data Stage Interview Questions

How to move data set from one server to other?what are the steps to follow to do this?

2 Answers  


What can we do with datastage director?

0 Answers  


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?

2 Answers   TCS,


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

0 Answers  


tab1 tab2 1,a 1,d 2,b 3,c perfoms outerjoin what is the o/p? write sql query for outerjoin?

3 Answers   Infotech,


How we can convert rows to columns in datastage?

4 Answers   IBM,


what is usage of datastage with materialized views

4 Answers   HP, TCS,


how to call routines in stages?

3 Answers   ME,


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

1 Answers   Wipro,


What are the third party tools you used in your project?

1 Answers   IBM,


How to Convert a string function to date function by using only sequential file stage with out using other stages ?

5 Answers   TCS,


Hi , Today 1000 records updated, tomorrow 500 records updated how to find that?

4 Answers   Wipro,


Categories