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

What are stage variables?

0 Answers  


What is ibm datastage?

0 Answers  


To see hidden files in LINIX?

0 Answers   CTS,


Source have 1000 records and it can have three nodes ok but i want how many records are executed on each node?

3 Answers   TCS,


Out of 4 mill records only 3 mill records are loaded to target and then job aborted. How to load only those 1 mill(not loaded records) for next run. This job is not sequential job, it is stand alone parallel job.What are the possibilities available in datastage8.1?

7 Answers   IBM,


how to create document in datastage?

1 Answers   Cap Gemini,


Which warehouse using in your datawarehouse

0 Answers   IBM,


what is sparse lookup?

7 Answers   IBM,


What is the difference between SQl Loader and OCI in datastage?

2 Answers   CSC,


why do u need the IOS upgradation in a FC switch

0 Answers   IBM,


Emp login_timestamp Logout_timestamp A,2019-02-01 02:24:15,2019-02-01 04:59:42 B,2019-03-29 14:43:30,2019-03-29 20:22:00 ABC,2019-03-29 12:43:00,2019-03-29 23:22:59 In the above calculate the duration of hours spent in office for each emp in datastage.

1 Answers  


How many types of sorting methods are available in datastage?

0 Answers  


Categories