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


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer



More Data Stage Interview Questions

what is the differeces between hash and modulus partition methods

4 Answers   TCS,


Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ manik.dwh@gmail.com 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5

2 Answers   IBM,


i have a scenario in which i/p columns areID,salary with 1,1000 2,2000 and 3,3000 i need an extra column in the o/p named avg(salary)how can i get it?

4 Answers   L&T,


How to convert RGB Value to Hexadecimal values in datastage?

0 Answers  


what is diff b/w datastage 8.1,8.5,8.7?

1 Answers   IBM,






i have a table col1 10 20 30 40 10 20 50 my requirement is how to retrive only duplicates like 10 10 20 20 like this how it's possible in SQL?

11 Answers   Cap Gemini,


deptno wise to find max and min,and sum of rows and in target to company wise maximum

1 Answers   IBM, TCS,


What is the difference between account and directory options ?

0 Answers  


What is the difference between an operational datastage and a data warehouse?

0 Answers  


create a job to get the previous row salary for the current row.if there is no previous row exists for the current row,then the previous row salary should be displayed as null? empid   salary   previoussalary 10      1000     null 20      2000     1000 30      3000     2000       40      4000     3000

5 Answers   Genpact,


How to perform incremental load in datastage?

0 Answers  


What is the default execution order of the sequential file?

3 Answers  


Categories