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
what is the differeces between hash and modulus partition methods
Anyone has Datastage certification free dumps for 000-418 , 000-421 codes, mail me @ firstname.lastname@example.org 000-418 : InfoSphere DataStage v8.0 000-421 : InfoSphere DataStage v8.5
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?
How to convert RGB Value to Hexadecimal values in datastage?
what is diff b/w datastage 8.1,8.5,8.7?
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?
deptno wise to find max and min,and sum of rows and in target to company wise maximum
What is the difference between account and directory options ?
What is the difference between an operational datastage and a data warehouse?
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
How to perform incremental load in datastage?
What is the default execution order of the sequential file?