As Adventure Works have Adventure works DW as a separate database, Do we also needs to create new database such as while working with "pubs" or any other do we need to create pubs DW separately or pubs will be sufficient for our working for sql analysis ?
Hi,
you should to create a new DW database (it′s a best pratice), but it′s not mandatory.
If you have a small production database, you will not percept the performance degradation...
So to create a DW (Dataware house) can be good to isolate OLAP from OLTP.
Regards
No comments:
Post a Comment