Welsh Corgi (1/15/2012)

---

I was given a VM Machine and it is to home to a Data Warehouse on one instance and Several Relational Databases on another instance.

The Relational DB's are...

Building on Ron and Jason's comments - once you have your home lab use and abuse Bools On Line (BOL) which comes free with your SQL Server. Read about architecture...

As far as I can see design solves the issue at hand.

Having said that, let me put my nose where nobody asked me to put it... Are you positive the...

safzalhussain (1/17/2012)

---

the data size may varry from 1.5 mln to 5 mln in a year. so at this moment if FULL refresh is suggested then will it also be feasible...

GilaMonster (1/17/2012)

---

Minimal transaction log activity, not none....

patrickmcginnis59 (1/16/2012)

---

Why did you feel the need to say "you don't even care about the basics of data modeling"? I thought it was an interesting case, but now your reaction...

:blink: would you mind in posting your business requirements as well as the schema of the involved tables?

I agree that it is a good idea to start with a single, simple datamart.

On the other hand, do not constraint your design to what your initial user spells out,...

safzalhussain (1/17/2012)

---

i m looking a best practice solution, to daily update bulk of records from Transaction Processing System (text files) into SQL Server database. we get large amount of data...

Please do not take it the wrong way but, out of curiosity, why is the subject of this thread "my favorite normalization case study" if you never intended to normalize...

I think you missed Barry Young's post on that one...

Would you mind in writting a query to answer the question... "Did Peter Bishop attend Particle Physics 501 on January 9th, 2012?"

Now... write a query to answer the same question...

http://www.sqlservercentral.com/Forums/Topic823529-22-1.aspx

Two comments.

First one. Not totaly sure about the snowflake DimCustomer-DimLocation structure... it looks like a plain 1-1 relationship which I usually try to avoid at all costs.

If the idea is...

danschl (1/16/2012)

---

it appears that DMO is not supported anymore in sql2008r2

EXEC @hr= sp_OACreate 'SQLDMO.SQLServer', @objServer OUT

so i was trying to convert to SMO

EXEC @hr= sp_OACreate 'Microsoft.SqlServer.Management.Smo', objServer OUT

Microsoft.SqlServer.Management.Smo.Server

...