building a dimension from multiple sources
3 posters
Page 1 of 1
building a dimension from multiple sources
What is the best method for building a dimension from multiple sources?
For example, we have patient table and a language table. We want to build the type 2 dimension with data from both tables. What is the best approach when the language description changed and the patient data did not change? The patient table is large and we do not want to process all the records from the patient table every day. We want to process only the changed rows from the patient table and the changed rows from the language.
For example, we have patient table and a language table. We want to build the type 2 dimension with data from both tables. What is the best approach when the language description changed and the patient data did not change? The patient table is large and we do not want to process all the records from the patient table every day. We want to process only the changed rows from the patient table and the changed rows from the language.
issddev- Posts : 2
Join date : 2013-01-31
Re: building a dimension from multiple sources
Exclude the language description from the process to Identify changes to the patients. After the load, update the language description in the dimension from the second source. I would add in a where statement to limit the updates to rows that actually had a different language desciptions (where d.Language_Desc <> S.Language_Desc). No sense updating rows with the exact same data.
Jeff Smith- Posts : 471
Join date : 2009-02-03
What is the best method for building a dimension from multiple sources?
Is there a way to implement a single step process?
issddev- Posts : 2
Join date : 2013-01-31
Re: building a dimension from multiple sources
Build a checksum, compare the incoming checksum to the dimensional checksum. If different, update.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Dimension with different sources (multiple business keys) ?
» Initial stage tables from multiple sources?
» Incremental load for a dimension table having multiple tables as sources
» Dimension Design with Multiple Data Sources (ORACLE and SQL Server)
» Multiple sources for the same data - which one to extract from?
» Initial stage tables from multiple sources?
» Incremental load for a dimension table having multiple tables as sources
» Dimension Design with Multiple Data Sources (ORACLE and SQL Server)
» Multiple sources for the same data - which one to extract from?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|