October 20, 2014 at 12:43 pm
First of all, I'm more than willing to explain it on skype with screen share, since that's probably easier to understand.
Skype: Spunned76
Here's my problem:
I've got 4 dimensions with patient data. Every dimension has a patient ID. I need to collect all the info about the patients from those 4 original dimensions into 1 new dimension, while only taking the info from patient 1024 across those 4 dimensions.
I've got no idea how to do this.. anyone got any suggestions? Thanks guys!
October 21, 2014 at 2:12 am
You only want data from one patient?
Is patientID the same across all dimensions?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 21, 2014 at 2:16 am
A few ways you could do this........
A Merge/Merge Join transformation (http://msdn.microsoft.com/en-us/library/ms141775.aspx)
A Lookup transformation (http://msdn.microsoft.com/en-gb/library/ms141821.aspx)
Do the join in SQL in your source.
The first two would require duplication of your efforts (i.e. more than one of each transform) whereas the third would be pretty easy if you are familiar with SQL. In fact, stay away from the merge transformations if at all possible as they are pretty bad in terms of performance.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply