DSXchange

Hi, I have employees who have contracts with Mobile Cariers Contracts are of 2 type 1) Continuous Span- where the employee is having contracts without a break Employee Eff Date End Date 10 01/01/2004 12/31/2004 10 01/01/2005 12/31/2005 10 01/01/2006 06/30/2006 2) Non Continuous Span- where the emplo...

Hi, I have a flat file which has data in the following format Dept Emp Sal 10 50 1000 10 50 2000 10 50 2000 10 20 3000 10 20 3000 10 20 4000 I am interested in picking up the employee , where sum(sal) is the highest.In the above case the expected result is Dept Emp Sal 10 20 10000 This is how i am d...

Thanks to all of u

Thank you DSGuru. However the problem is much bigger. I am selecting around 60 columns from some 4-5 Dimensional Views and i am almost at the rim of hitting the 64 Join Parser Limit.So i do not really wanna join to the same view once again . Is there any option through DataStage that i can achieve t...

Hi , I have a Table with such kind of info Region Dept Emp Sal South 10 Sam 10 South 10 Tam 20 South 20 Pam 40 North 30 Cam 50 North 40 Mam 100 North 40 Dam 50 I need information Rolled up at both Region and Dept Level Total Salary for Region South is 70 Dept 10 = 30 Dept 20=40 Total Salary for Regi...