The first requirement would be to know how it should be handled. Would the add be...

In my opinion these kinds of low-level integrity issues are best handled by triggers similar to the ones above. The comment about some organizations not liking triggers could be...

This sounds a really simplistic question, but based on what you've said, it should just be:

update xys set submitdate=NULL where id in ('1','2'.........'100')

I feel I must be missing something as...

Even well known data such as postal codes can change and easily become stale quickly. How many developers are willing to write import routines to update this data for something...

Another question: how important is it to use a surrogate or artificial key for the dimension tables? Could I get away with just using the FK from the source system...

Forgot to make clear that the dates are not stored in the fact table as dates, but as pointers to your calendar table. You can join the same table...

Sorry, but I'm not seeing how that's the grain. As best as I understand it, there is something that goes through a certain lifecycle that includes an open date, some...

What exactly is the grain of the fact table? Once you know that, you can decide how to solve this issue. It's not clear to me what you...

There might be, but I don't know why you don't want to use the redirection. If marking them as an error is important, then redirect the error rows into...

Lots of my reasons have already been said, but I would add that for those of us who are the sole SQL Server person in the company, it's also a...

Lots of good ideas here already, but let me add:

I don't use the YYYYMMDD system for my keys, but integers instead. It's very Ralph Kimball, and it's disputed because...

Your own preference is key here. There are lots of good DBAs who aren't good BI developers. I don't know that it's so much the other way around....

I have 1,442 rows in my time dimension and use a smallint as the key. It works very fast, even against my largest dimension, which has over 2 million...

My experience is that adding columns or deleting columns that aren't otherwise used has no effect on the download process. When you open the SSIS package in design mode,...

Try clicking Test Cube Security on the Cell Security tab. I found that necessary even though I wasn't using cell security. It's not at all an intuitive step...