Data mart design
dshapourian at 19h55
13
Dec
2010
Data mart design
Lets say I need to model Frauds. There is 2 departments handle different Frauds say (Contract and Health care). I am going to model this in MD (fact, dimension). Now should I just create one Fact table(Business Process) and use say Fraud type (Contract, healthcare) as one of the dimensions (some dimensions will be specific to Fraud type, it will leave an empty cell in the fact table)? or should I create 2 different Fact table one per each Fraud type using conf dimensi
Lets say I need to model Frauds. There is 2 departments handle different Frauds say (Contract and Health care). I am going to model this in MD (fact, dimension). Now should I just create one Fact table(Business Process) and use say Fraud type (Contract, healthcare) as one of the dimensions (some dimensions will be specific to Fraud type, it will leave an empty cell in the fact table)? or should I create 2 different Fact table one per each Fraud type using conf dimensi
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
The project I am working on has a requirement to report on actuals against targets. An example might be the number of sales calls made by a sales rep during the month for a specific customer compared to the targets set for that customer.
Is this
Hello there,
Considering the case that i am assigned to work on, which is to decide on the most appropriate schema to be chosen for the Data Warehouse / Business intelligenece Project.
First of all, i would like to know the available options for me,
We are working at client site where we recommended using the BUS architecture and we are using PPS Monitoring for dashboards. Our client has been re-building each data mart nightly for now and they are re-building each data mart dimdate dimension with row
If I have a fact table with too many dimensions --- over 30, does that mean I've created dimensions when they could have been attributes to another dimension table or possibly that I am trying to capture too many business processes within one fact table.
This tip suggests that we can eliminate the minute dimension and have a full time stamp in the fact row.I need more clarification on how this could be implemented. For instance if I need a fact to be shown with 1/2 hour split down how could I do it withou
Forums from same category
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
LEGO Island Discussion, modding, news and more!
HmongThoobNtiajTeb. com/
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Search
See also
Informations
7 Replies For the topic :
"Data mart design"
This topic has been viewed 1696 times.
Last message :
13/12/2010 at 19h55 by "dshapourian"
