Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need to create a data model for stock control .The database is from sage 200 .I have a query regarding this.The stock control module has Stock item,Bin Item and Warehouse Item tables and their quantities constantly change.I am creating a data model with dimensions on one side and all events on one side so should I create separate event tables for stockitem,binitem and warehouseitem or integrate all into one event called stocks.Will give you more information if you require.thanks in advance.
I personally haven't worked with SAP but from personal experience a centralised fact table for item movement is fairly normal