Hi all,
Am newbie to informatica.Here is one reqd that is badly neded for me :
In 'n' number of records ,ie , emplyees with their salaries in one column,we need to get those employees details whose salary is equal to the sum of all the other employees.
Say,
-20 employees,ie , 20 records
-the data should b read from 1st record ..so check 1st record salary = sum of the other 2-19 records salary,if so get the details...
-this procedeure should continue from 1st ,2nd and so on to 20th record...
I need the flow of transformations reqd by step-wise procedure.
If anymore explanation is reqd pls ask.Great help i s needed.
Thanks,
D.V