Please find attached a spreadsheet I prepared with an outline of staging tables required to support the APO Data feeds.
Please note that this document is still a work in progress and *does not* yet contain all the staging tables needed.
My current focus has been to align the Hierarchies, Attributes and Retail Index data.
I am yet to complete the requirements for POS / T1C into this document
Also note that, in the spreadsheet, I have not yet started naming the tables, as I was unsure of the RIS/CFR naming conventions.
I’ll walk you through this spreadsheet in the morning, and we can discuss any questions you have.