Find unique records based on another field
Posted: Mon Dec 31, 2012 12:34 am
Hi All,
My requirement is
Emp No, Emp Name
12345, skp
14567, skp
43567, skp
56789, skp
45678, rjp
23456, skp
45236, mkp
Group by Emp Name I have to find out if more than one employee is there I need to pass to target else I have to reject and capture the records.
Target O/P
12345, skp
14567, skp
43567, skp
56789, skp
23456, skp
Reject O/P
45678, rjp
45236, mkp
In datastage how we can achieve this... Appreciate your help...
Thanks,
skp.
My requirement is
Emp No, Emp Name
12345, skp
14567, skp
43567, skp
56789, skp
45678, rjp
23456, skp
45236, mkp
Group by Emp Name I have to find out if more than one employee is there I need to pass to target else I have to reject and capture the records.
Target O/P
12345, skp
14567, skp
43567, skp
56789, skp
23456, skp
Reject O/P
45678, rjp
45236, mkp
In datastage how we can achieve this... Appreciate your help...
Thanks,
skp.