144 reputation
6
bio website
location
age
visits member for 2 years, 2 months
seen Apr 1 at 16:53

I like to code.


Nov
15
awarded  Popular Question
Jul
18
awarded  Popular Question
Sep
28
accepted Who changed/modified stored procedure in SSMS 2005 or 2008?
Sep
27
comment Who changed/modified stored procedure in SSMS 2005 or 2008?
Thanks Martin, I am not very versed in this arena, I had read something of that sort but wasn't sure if it was true.
Sep
27
comment Who changed/modified stored procedure in SSMS 2005 or 2008?
Yes this is very similar to that question, I didn't see that one, my problem unfortunately continues as you can see in my original question I have already tried the most highly voted answer of that question.
Sep
27
comment Who changed/modified stored procedure in SSMS 2005 or 2008?
Definitely a plus one for solving the problem in the future many thanks Max.
Sep
27
revised Who changed/modified stored procedure in SSMS 2005 or 2008?
deleted 1 characters in body
Sep
27
asked Who changed/modified stored procedure in SSMS 2005 or 2008?
May
25
comment SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
Thanks Gonsalu.
May
25
accepted SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
May
23
asked SSAS -> New cube contains two fact tables. How do I relate these so I can use measures from both at the same time?
May
1
awarded  Editor
May
1
revised SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
Adding data example
May
1
awarded  Supporter
May
1
awarded  Scholar
May
1
accepted SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
May
1
comment SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
I will let you know how this turns out thanks for all the information.
May
1
comment SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
I uploaded an image of a data example, just to make sure you understood what a record of data looked like for this dimension. After seeing this, do you still think that each level requires a surrogate key? (Note* in my picture of dimension LineOfBusiness = LineOfBusinessId.....same for Division and Worker)
May
1
suggested suggested edit on SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
May
1
comment SCD Type 2 Dimension -> Is this the correct layout for a type 2 scd with this type of data present?
Hi Concerned, thanks for your answer. So, are you saying that my key columns would now contain LineOfBusinessId and LineOfBusinessSurrogateId? And it would be like this for each level? Each with its own surrogate key? This worries me because we are not using SSIS to populate our data as it comes from a legacy system. So, we would in turn have to rewrite all the code in our legacy system to provide surrogate keys for each level. Do have any suggestions beyond providing a surrogate key for each level? We can do this if we need but it will be a lot of work. Thanks.