No, I do not agree.

Regarding the fact, if it can change, it is probably an accumulating snapshot.  You should update the changes.

Regarding the dimension, you need to determine if tracking...

• This reply was modified 2 years, 1 month ago by  RonKyle.

You seem to be confusing fact and dimension tables.  A fact table cannot be 2SCD.  The "D" is 2SCD stands for dimension.

That you do this as a snapshot does NOT...

That is not enough information to suggest a design, and coming up with a design takes many hours of analysis and usually interviews to some degree.  I would suggest you...

You are asking if this approach is a good design, and I would have to say, based on what you present here (which isn't much) it is not a good...

non-sequential keyed indexes (such as Random GUIDs) are the worst thing you can do

Not sure where you are going with this one.  I've seen GUIDs used TOO many times where...

No.  I mean that as I cannot get the environmental parameters to work, I have to actually change the server names in the BIDS environment to either the dev server...

I was imprecise with flip.  I should have said "change" the server.  As there are two choices for me, it's like "flipping" a switch.

"Runtime values for package parameters and connections can be assigned from SSISDB 'environments'. These environments allow the encryption of 'sensitive' values (eg, passwords)."

I have not been able to make this...

One big con depending on what version you are doing is that in Project mode deployment of individual packages isn't possible.  You have to deploy the entire project.  This was...

Completely agree with the consistency argument.  I've seen inconsistency within even the same stored procedure written by a single person.  I also like the single letter table.  I've rarely run...

No doubt.  But the EOMONTH function could have been introduced with the presented one as an alternative.

You would be in the best position to make the justification by learning what are the new features and then seeing if you can make a business case for why...

There is an EOMONTH function to get you the end of the month.

I have a good idea of what I don't know by reading SSC.  There are things I know well, things I know well enough, things I should know better, and...

Call your Time_Dimension Date_Dimension instead.  Kimball called this time in his first edition book, but revised it to Date by the second edition.  Eventually you may have a need for...