Various Data ModelingLinks

https://greatobi.wordpress.com/2009/07/16/modeling-header-details/


https://dba.stackexchange.com/questions/23056/how-do-you-roll-up-header-level-values-on-a-fact-table-with-line-item-granularit


---Date Modeling Techniques
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/




---Datawarehouse Lifecycle Planning toolkit
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-lifecycle-toolkit/


---- Naming Convention - list of abbreviations(From Kimball reference)
http://www.indiana.edu/~edss/Services/Naming/nameDisplay.pl?table=ab


---- Kimball Reference for documents related to building a Datawarehouse
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/microsoft-data-warehouse-dw-toolkit/


Data Warehouse3 toolkit by Ralph Kimball
https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/books/data-warehouse-dw-toolkit/




 Data warehousing Methodologies


https://blog.westmonroepartners.com/data-warehouse-architecture-inmon-cif-kimball-dimensional-or-linstedt-data-vault/


https://www.kimballgroup.com/2009/05/the-10-essential-rules-of-dimensional-modeling/


https://www.jenunderwood.com/2017/07/14/back-to-dimensional-modeling-basics/


Various Data models CSU


http://www.databaseanswers.org/data_models/index.htm




 ---HR Model Very good example


http://www.databaseanswers.org/data_models/hr_platform/index.htm


https://www.databasejournal.com/features/oracle/article.php/3529531/Database-Modeling-Using-Visio.htm


https://www.opm.gov/services-for-agencies/hr-line-of-business/enterprise-architecture/hrlob_dm.pdf  ** Very good example of Project Planning


https://subscription.packtpub.com/book/big_data_and_business_intelligence/9781782173250/7/ch07lvl1sec37/human-resources-data-model


http://tdan.com/a-universal-person-and-organization-data-model/5014


https://www.oracle.com/technetwork/developer-tools/datamodeler/sample-models-scripts-224531.html


https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-modeling-nosql-B.html


http://web.mit.edu/warehouse/metadata/stars/business_area/human_resources.html




----Multiple Models
http://www.databaseanswers.org/downloads/Dimensional_Modelling_by_Example.pdf
---- Invoice Header


https://www.kimballgroup.com/2007/10/design-tip-95-patterns-to-avoid-when-modeling-headerline-item-transactions/


https://www.slideshare.net/nongoffna/data-warehouse-order-management?from_action=save


http://www.b-eye-network.com/view/9910


https://www.nuwavesolutions.com/degenerate-junk-dimensions/




https://www.researchgate.net/publication/237622501_Chapter_I_Conceptual_Modeling_Solutions_for_the_Data_Warehouse





Many to Many Facts examples
https://hub.packtpub.com/solving-many-many-relationship-dimensional-modeling/


https://www.codemag.com/article/1304071/The-Baker%E2%80%99s-Dozen-13-Tips-for-Basics-of-Data-Warehousing-and-Dimensional-Modeling


https://www.nuwavesolutions.com/bridge-tables/


https://www.vertabelo.com/blog/technical-articles/five-common-dimensional-modeling-mistakes-and-how-to-solve-them - using a additional fact table




Edit Model in A browser
https://my.vertabelo.com/model/Rq7DHBGO83r5piJZJ16j61Tsn0oozsrU




https://www.vertabelo.com/blog/technical-articles/data-warehouse-modeling-the-snowflake-schema




How to load Fact Tables


https://www.tek-tips.com/viewthread.cfm?qid=1643616


https://social.technet.microsoft.com/Forums/en-US/7cba63e1-6742-4db5-8011-44a8fea8c041/slowly-changing-facts-creation-with-scd-type-2-dims-tables?forum=sqldatawarehousing


https://martinschoombee.com/2011/11/16/temporal-fact-tables/


https://www.kimballgroup.com/2008/11/fact-tables/




http://www.zentut.com/data-warehouse/fact-table/


Temporal Modeling
https://www.linkedin.com/feed/update/urn:li:ugcPost:6497167178356318208


Google Search : what is a key of a fact table in a data warehouse


https://stackoverflow.com/questions/21606750/is-there-a-concept-of-slowly-changing-fact-in-data-warehouse




https://www.researchgate.net/publication/330798405_Temporal_Dimensional_Modeling

How to load facts - contd

https://stackoverflow.com/questions/21606750/is-there-a-concept-of-slowly-changing-fact-in-data-warehouse

https://it.toolbox.com/question/efficient-way-to-update-fact-tables-in-warehouse-101110

https://dwbi1.wordpress.com/2015/02/09/populating-fact-tables/

http://www.dbta.com/Columns/Database-Elaborations/Updating-Fact-Rows-In-a-Star-Schema-Set-of-Tables-is-Not-a-Good-Practice-118541.aspx

https://dwbi1.wordpress.com/2015/02/09/populating-fact-tables/