Still shows I'm wrong, but no worries.  Not a big deal.

Can you fix my wrong answer? 🙂

I'm not sure about this.  It's a pretty common trigger to update the last updated date.  By default, that trigger does not cause the trigger to fire again.  Otherwise it...

@jeff Moden.  It's all  but impossible to imagine a data warehouse without a date dimension.  Not impossible though.

As you point out, the PK for a date dimension is...

I don't doubt that.  I remember my first data warehouse.  But I got my grounding by reading the Kimball books.  While I'm happy to teach my colleagues, I'm able to...

If any part of the dimension is a type 2, it's probably a 2, and only a two.  An SCD7 would be difficult to implement (it didn't even exist until...

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 1 year, 5 months 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...