Mapping Tables Not giving us accurate data
Summary:
Mapping Tables Not giving us accurate data
Content (please ensure you mask any confidential information):
We are replacing our old system of EBS with ADW. When recreating the data warehouse we have mapped our tables to ADW/Augmentations. When going through two of our final tables we have done the mapping the best we can based on endless research/knowledge and with the mappings we have tried we are receiving duplicate data. We are requesting a working session to go through what the best practice would be for these two EBS tables:
GMS_BALANCES
PA_SUMMARY_PROJECT_FUNDINGS
We are going live in an under a month and need a quick turn around as this has a downstream impact on reports/ many of our other system processes as well.