solution required for a problem in informatica-urgent
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
Re: solution required for a problem in informatica-urgent
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.
Re: solution required for a problem in informatica-urgent
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
Re: solution required for a problem in informatica-urgent
Hi,
Pls can anybody help me in this issue?
Its urgent ...any help is more appreciated!!
Thanks,
D.V
Re: solution required for a problem in informatica-urgent
[QUOTE=venmala;16580]
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...
[/QUOTE]
So, It can be solved by using SQL query easily -
[FONT="Courier New"][COLOR="DarkRed"]Select * from EMP A where sal =
(Select sum(sal) from emp A where A.empid = B.empid)[/COLOR][/FONT]
If you need any further info - pm me.
[QUOTE=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.[/QUOTE]
[COLOR="Indigo"]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?[/COLOR]
[B]Sanghala[/B]
Re: solution required for a problem in informatica-urgent
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
Re: solution required for a problem in informatica-urgent
[QUOTE=venmala;16732]
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
[/QUOTE]
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...
[B]Sanghala[/B]