Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

building a dimension from multiple sources

Go down

building a dimension from multiple sources Empty building a dimension from multiple sources

Post  issddev Thu Jan 31, 2013 2:55 pm

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.

issddev

Posts : 2
Join date : 2013-01-31

Back to top Go down

building a dimension from multiple sources Empty Re: building a dimension from multiple sources

Post  Jeff Smith Fri Feb 01, 2013 1:30 pm

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

Back to top Go down

building a dimension from multiple sources Empty What is the best method for building a dimension from multiple sources?

Post  issddev Fri Feb 01, 2013 2:36 pm

Is there a way to implement a single step process?

issddev

Posts : 2
Join date : 2013-01-31

Back to top Go down

building a dimension from multiple sources Empty Re: building a dimension from multiple sources

Post  BoxesAndLines Fri Feb 01, 2013 2:51 pm

Build a checksum, compare the incoming checksum to the dimensional checksum. If different, update.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

building a dimension from multiple sources Empty Re: building a dimension from multiple sources

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum