mgerritt
Well Known Member
We are in the planning stage of a data warehouse, wherein we will combine the sales records of 4 businesses, each with a separate data library. And thus, address book numbers are duplicated within each business. Not a problem for sales (F4211) records as the company numbers are different, and thus sdkcoo||sdan8 is unique. But the Address book does not use company number in any of the files. Has anyone addressed this issue in building a data warehouse and found a way in JDE to define a unique identifier for each customer. Or are we going to have to do this by adding info during the ETL step?