Fact table for stock market transactions
Page 1 of 1
Fact table for stock market transactions
Hi all,
I'm working on an enterprise data warehouse. Inside my EDW I have two almost common tables, order and order entry.
For the datamart, representing (in two words) the business process of customer analysis of market orders, I thought to create a transactions fact table holding for each line a single order entry, with columns like:
- date
- order nr
- order type (Sell/buy)
- quantity
- amount
- product
Dimensions should be: date, product, customer, order (?)
My questions are two:
- do you think that approach is overall correct?
- Considering to have some financial indicator calculated inside the DWH, how you put for example the AUM (asset under management) indicator in format YTD, YTQ, YTM (Year to day, quarter or month)?
Thanks
Ste
I'm working on an enterprise data warehouse. Inside my EDW I have two almost common tables, order and order entry.
For the datamart, representing (in two words) the business process of customer analysis of market orders, I thought to create a transactions fact table holding for each line a single order entry, with columns like:
- date
- order nr
- order type (Sell/buy)
- quantity
- amount
- product
Dimensions should be: date, product, customer, order (?)
My questions are two:
- do you think that approach is overall correct?
- Considering to have some financial indicator calculated inside the DWH, how you put for example the AUM (asset under management) indicator in format YTD, YTQ, YTM (Year to day, quarter or month)?
Thanks
Ste
oraclepilot- Posts : 1
Join date : 2012-11-28
Similar topics
» fact tables for stock market analysis
» Market Share in Fact Table
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» Fact, Dimension or Both? Healthcare Call Transactions and Populations...
» Market Share in Fact Table
» 'Routing' the grain of the fact table to multpile members of multiple dimensions causes the fact table to 'explode'
» Integrating new fact table which has one to many relationship with the main fact table in existing star schema
» Fact, Dimension or Both? Healthcare Call Transactions and Populations...
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum