Description

Warehouse entity dimension table contains cross reference entity information between different source ERPs. As an example, this is where the true pidm for Banner is stored or the true id_number for Advance is stored. A one-up number is generated for the UID. This way if the person exists in both source systems, it allows that person to exist as a single entity, rather than one separate to each Advance and Banner.