building a dimension from multiple sources

View previous topic View next topic Go down

building a dimension from multiple sources

Post  issddev on 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

View user profile

Back to top Go down

Re: building a dimension from multiple sources

Post  Jeff Smith on 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

View user profile

Back to top Go down

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

Post  issddev on 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

View user profile

Back to top Go down

Re: building a dimension from multiple sources

Post  BoxesAndLines on Fri Feb 01, 2013 2:51 pm

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

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

View user profile

Back to top Go down

Re: building a dimension from multiple sources

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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