Datastage px

[thodeti]

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

[ray.wurlod]

Welcome aboard.

Thank you for posting an intellectual exercise in database design.

What assistance do you believe an ETL tool might bring?