solution required for a problem in informatica-urgent

[venmala]

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

[saibabu]

use only SQ TRANS and use sql overide property and specify the query which will give the results as per u r requirement.no need of any other transformations.
i hope this will help you.

[venmala]

Thanks saibabu,

BUt can you pls help me in framing the query...i wil be trying from my side too...as its an urgent requirement i was been forced to ask u even the query...dotn take me otherwise..


Thanks,
D.V.VIJAY

[venmala]

Hi,

Pls can anybody help me in this issue?

Its urgent ...any help is more appreciated!!

Thanks,
D.V

[sanghala]

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...

So, It can be solved by using SQL query easily -

Select * from EMP A where sal =
(Select sum(sal) from emp A where A.empid = B.empid)

If you need any further info - pm me.

use only SQ TRANS and use sql overide property and specify the query which will give the results as per u r requirement.no need of any other transformations.

Then waht is the need of Informatica. You can do it by just writing a SQL query.

There is other way to do this. Refer once again what here is required?

Sanghala

[venmala]

Hi,

Thanks for the query ... from here i can go up with the transformations.

But realyy thanks a lot..Am really happy for the exact response i got

Can i hav ur email id for any further contact and prompt response

Thanks,
D.V

[sanghala]

Thanks for the query ... from here i can go up with the transformations.

But realyy thanks a lot..Am really happy for the exact response i got

Can i hav ur email id for any further contact and prompt response

Yep... But as Saibabu told - I donot know you will get the desired form or not.
But by using Lookup and Filter/Router you can achieve this.

Try it and update what output you got....! For Geek reference...

Sanghala