Financial/Accounting Data warehouse model design - need advice!!!
-
I am researching some standard models for Datawarehouse of accounting/ financial model? Is there any recommended books or knowledge base for these? I would like to find some best practice samples or the good way to identify the model. Any advice is really appreciated. Thanks!
-
I am researching some standard models for Datawarehouse of accounting/ financial model? Is there any recommended books or knowledge base for these? I would like to find some best practice samples or the good way to identify the model. Any advice is really appreciated. Thanks!
He's got every model and relation under the sun. Sometimes its easier to reverse engineer Quick Books or something similar. [https://www.amazon.ca/Len-Silverston/e/B000APUYFQ/ref=dp\_byline\_cont\_book\_1\](https://www.amazon.ca/Len-Silverston/e/B000APUYFQ/ref=dp\_byline\_cont\_book\_1) For data warehouses (publications), the keyword is "snow flake".
"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I
-
I am researching some standard models for Datawarehouse of accounting/ financial model? Is there any recommended books or knowledge base for these? I would like to find some best practice samples or the good way to identify the model. Any advice is really appreciated. Thanks!
-
I am researching some standard models for Datawarehouse of accounting/ financial model? Is there any recommended books or knowledge base for these? I would like to find some best practice samples or the good way to identify the model. Any advice is really appreciated. Thanks!
Slowly Changing Dimensions.
Understanding Indexing.
Indexing the Data Warehouse.
Understanding Index Views.
Understanding Data Compression.
Data Lineage.
Using Partitions.
Identifying Fact / Dimension Tables..