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

Can we use sequential file as source to hash file? Have you do it ?if what error it will give?

1 Answers   SS Solutions,


How rejected rows are managed in datastage?

0 Answers  


Source contains the metadata source ----- hyderabad,chennai,bangalore by using nested loop sequence select source as hyderabad in target just run target as hyderabad only not others please give me answer thanks in advance(give reply how to wrote logic using nested loop sequence)

1 Answers   IBM,


Lookup constraints

0 Answers   CTS,


Thanks to all people who are posting their comments...

1 Answers   CTS,






What are the main differences you have observed between 7.x and 8.x version of datastage?

0 Answers  


A table containg 100 records B table containg 20 records we have to join two tables in left outer it containg target 100 records but target containg 101 record at that time what is the issue arise

3 Answers   Polaris,


In merge stage can we update the values?

3 Answers   TCS,


What is Ad-Hoc access? What is the difference between Managed Query and Ad-Hoc access?

0 Answers  


what is the exact difference between dataset and fileset in datastage?

5 Answers   TCS,


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)

0 Answers  


What are data elements?

0 Answers  


Categories