ETL will load this normalized Integration layer first before transforming it again to populate the star schemas of the Presentation layer, which better support user-friendly BI applications. Designers will model a traditional Integration layer with tables in third, fourth, or fifth normal form. The standard normal form implies a very traditionally structured data warehouse, one with an Integration layer and a Presentation layer. To understand the advantages of the agile techniques that are demonstrated in the following chapters, EDW team leaders must first understand the weaknesses of the two traditional approaches: standard normal forms and conformed dimensional forms. Ralph Hughes MA, PMP, CSM, in Agile Data Warehousing for the Enterprise, 2016 SummaryĮvery EDW team starting upon a new warehouse or major subject area is at a crossroads where they must choose to follow either traditional data modeling techniques or one of the new agile approaches.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |