This is a double post. Until an editor can fix it, here is the reply I added on the other thread:

Based on what you've provided, I would suggest that...

Based on what you've provided, I would suggest that you would use an accumulating snapshot fact table. The row is revisited when there is a change. The record...

Create an Excel spreadsheet which contains only field headings/formatting, but no data. This is your template - put it on a network share somewhere.

Then, rather than deleting from Excel, just...

I have also occassionally seen the colors not turn as expected but everything is okay. Not even sure it's an SSIS issue, but the only way to check to...

I don't recommend this. All dimension keys should have some value. Implement the third suggestion in the above post. ...

You might want to do some research some stuff by Ralph Kimball. I remember one of the articles talking about the complexity of making a DW for a bank...

I don't think this is sufficient information to analyze the problem. If you still need assistance, would you please provide more details.

Thanks,

I'm designing a DW for the convenience store industry. This is just for transactional data that happens on the point of sale system. Each transaction may have multiple items and...

There's not enough here for me to be sure this will help, but:

The date time entries you have should arrive in two columns, one column which points to the date...

I second the choice for The Data Warehouse Toolkit. Depending on your platform, however, there is a SQL Server 2005 version of the MS Data Warehouse Toolkit to consider.

Pay...

I don't have mine configured to ignore errors, but as you have a bunch of these, I would beat that it IS ignoring the errors in the sense that it...

I'm sorry, but you're still not providing enough information for me to give you an answer that might even remotely be what you are looking for.

Let me give an...

What exactly are you looking for? I have a couple of dimensions that use SCD 2, but they are by definition not simple (compared to SCD 1 in any...

If I have source data from multiple sources I stage it into one table then run it through the KimballSCD , or just union the sources in the flow before...

2) I interchange the terms "datamart" and "datawarehouse", but datamart infers some smarts you can get out of the system , where as to me a data warehouse is just...