I worked at a place like this and it worked very well. They had the highest standards of any company I've worked for and they had a good work...

#1 - Yes it is common practice to compare data in staging with the data warehouse.

#2 - Because of #1 I don't care if rows in staging are marked as...

You need to setup a linked server for this to work.

Larry, it appears you have a minor syntax issue with the current query so I would recommend you fix that to get it to run. It's probably just a...

There's a number of errors in your syntax with quotes and parentheses in the wrong place. Try changing it like this:

Insert into MarketBasketModel_Structure( CustomerId, Gender, Income, MemberCard,

Purchases( ProductName, Quantity)...

I'm glad I could help so it's good to hear this has been useful.

With decision trees arriving at the same answer using multiple paths, the paths are not necessarily mutually...

John,

I'm not sure you can get exactly what you want so I'm trying to suggest the closest you can come to it. This is where you can use more...

Yes it seems you want to use regression. Clustering is a good algorithm for understanding your data, but if you want to predict a value like Purchase Amount based...

John, to answer one of your questions, yes, what you are doing is definitely data mining. With SQL Server you can do what you want with Analysis Services either...

You can load data in any order using partitioning, so you will be able to do what you want and load more current data first, then older data later. ...

My suggestion for your case is to not split the table into multiple tables unless you have a clear-cut reason to do so, and simply splitting it up because it...

I always create time as a separate dimension also. A current manufacture I'm doing this for has the following time dimension. Of course, it is based on their...

When the numbers in your fact tables don't add up, then you haven't set the grain properly. A subscription fact does not seem to me to be the same...

I think showing work you've done applies only to anything that would already be publicly available; a public web site, a paper you've published, a side project you can demontrate,...

This is an area that's still more art than science and we definitely need to get better at it. Too often interviews don't challenge the candidate in the subject...