Hi Everyone,
What is the structure for historical ref tables. I have read through @patrickcuba 's blog and book on this. I have 3 broad questions on this:
- What metadata columns should be added to ref tables? - tenantid, bkeycode, loadts,recosource, apptts?
Recsource, loadts and appts should be good enough in my case - How to handle ref table coming from multiple sources (hub - multiple sats for each source?)
- I understand there are 2 ways to model this: hub-sat pair (historical ref tables) or 1 entity table. In case of 1 entity table, will I be creating 1 entity table and inserting data for multiple sources or do I need to create seperate tables/source?