In Power Pivot and Analysis Services Tabular, all data is stored in memory. However, if a business has many products available in stock and most of them do not have movements every day, then the Inventory table might have a size that is a multiple of the Movements table. A business that every day has a large number of transactions for most of the products in stock would prefer using the Inventory table because it is smaller than the Movements one. The size of an Inventory table might be huge. There should be some batch processing (usually part of the ETL nightly process) that updates this table every day and the size of this table increases every day by the number of products available, assuming you do not store a row for products that are out of stock. The Inventory table is also known as a “snapshot” table, which means that for every day you have a complete description of the stock availability. Such a table makes it very quick retrieving the stock amount of one or more products because you have to sum only the rows for a single day. When you want to analyze stock inventory over time, the traditional approach is creating an Inventory table that contains, for every day, the quantity for every product that is in stock.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |