Called EXTRACT TRANSFORM LOAD ETL Aside: ETL design and related data source issues can often take 1/3 of the overall time to complete a data warehouse project. Time Dimension 04-2 By using a time series have the problems of changing data been solved? NO Time series can still have problems representing history correctly The problem still is about -- if you are not careful. Descriptive data (attributes) can change over time. Slowly Changing Dimensions Called EXAMPLE of SLOWLY CHANGING DIMENSION 04-2.4
Called EXTRACT TRANSFORM LOAD ETL Aside: ETL design and related data source issues can often take 1/3 of the overall time to complete a data warehouse project. 04-2 Time Dimension By using a time series have the problems of changing data been solved? NO Time series can still have problems The problem still is about representing history correctly -- if you are not careful. Descriptive data (attributes) can change over time. Called Slowly Changing Dimensions 04-2.4 EXAMPLE of SLOWLY CHANGING DIMENSION
04-2-Time-Dimension%20-%20Slowly%20Changing%20Dimensions.docx