Datastage px
Posted: Tue May 05, 2009 11:08 pm
Please find the details about the problem
Source data containing the fields Location,Item,Person and the values as below.
1. Location -L1.......Ln
2. Item -I1...........In
3. Person -P1----------Pn
1. A person can sell any item in any loaction.
2. If P1 sells an item(I1) in L1 then P2 does not have authority to sell I1 in L1 location
3. P2 can sell other items (except I1)in L1 location at the same time he is having authority to sell I1 ohter than L1 location.
Any person should not sell the duplicate items in one location
Source data containing the fields Location,Item,Person and the values as below.
1. Location -L1.......Ln
2. Item -I1...........In
3. Person -P1----------Pn
1. A person can sell any item in any loaction.
2. If P1 sells an item(I1) in L1 then P2 does not have authority to sell I1 in L1 location
3. P2 can sell other items (except I1)in L1 location at the same time he is having authority to sell I1 ohter than L1 location.
Any person should not sell the duplicate items in one location