I am working for a manufacturing company and I am creating a datamart for stock and delivery analysis.
We have the big amount of delivery and the sales transaktion.
The problem is that delivery has a big gap before the first
transaction will came.
We need to keep track and calculate stock amaunt from the
first delivery for product and location.
I want to avoid to store the unchanging delivery and stock store in fact table. The fact table is alrady around
500 000 000 rows. How i can calculate stock and fined last change record with a god prestanda.
Mi DW is on Oracle.
Thanks for all tips
We have the big amount of delivery and the sales transaktion.
The problem is that delivery has a big gap before the first
transaction will came.
We need to keep track and calculate stock amaunt from the
first delivery for product and location.
I want to avoid to store the unchanging delivery and stock store in fact table. The fact table is alrady around
500 000 000 rows. How i can calculate stock and fined last change record with a god prestanda.
Mi DW is on Oracle.
Thanks for all tips