logic implementation
Posted: Mon Mar 28, 2011 12:52 am
Hi Ray
Can you please let me know how to implement this logic in server job or in the source sql query
Input :
Account id Flag
123 Y
123 Y
124 Y
124 N
125 N
125 N
Output :
Account id Flag
123 Y
124 Y
125 N
In the source,
If there is flag as 'Y' for any of the one record with the same account id ,we should have target also as 'Y' only,
If there is 'Y' for one record and 'N' for another record with same Account id ,we should have 'Y in the target.
If the flag from the source for all the records as 'N',then only we should have target as 'N'
In target Account id is unique...
Thanks
Kiran
Can you please let me know how to implement this logic in server job or in the source sql query
Input :
Account id Flag
123 Y
123 Y
124 Y
124 N
125 N
125 N
Output :
Account id Flag
123 Y
124 Y
125 N
In the source,
If there is flag as 'Y' for any of the one record with the same account id ,we should have target also as 'Y' only,
If there is 'Y' for one record and 'N' for another record with same Account id ,we should have 'Y in the target.
If the flag from the source for all the records as 'N',then only we should have target as 'N'
In target Account id is unique...
Thanks
Kiran