Is there a proper way to use a snowflake design?

Hello,

I am trying to develop a cube that includes employee counts. Looking at Ralph Kimball's article about Human Resource data
http://www.dbmsmag.com/9802d05.html it looks like I should have an Employee Transaction Dimension table of all the employees and all their actions over time. I also should have a fact table which "is a snapshot that contains monthly numeric summaries that are difficult to calculate from the underlying transactions." That all works for me.

My question is, what is the next step with this? Specifically, I need to have dimensions on the Employee Transaction Dimension table such as their Department, Location, Rating, Gender, etc. Do I have those dimensions (Department, Location, Ratings, etc.) as a dimension on the Employee Dimension table or do I put them directly on the Fact table?

Also, will Analysis Services be able to deal with that? Meaning will I still be able to browse the cube correctly?

Thanks for the help.

-Gumbatman

Hi Gumbatman,

It will be hard to give you details answer of this question. You need to go over data model books.

Quick answer is as you might know in fact table you keep only numeric measures and key fields to your dimensions.

Looks you need dimensions employee, department, location, ratings, gender and keep transactions in fact table.

-Ashok

sql

is sql 7.0 scheduled to be retired

In e-Week (Dec 15, 2003 pg 8) an article mentioned that Windows 98, sql
server 7.0 and a number of versions of office 2000 are scheduled to be
retired by Dec 23 as part of the agreement with Sun over the Java lawsuit.
Can anyone point me to a press release or list of products that are
scheduled to be retired as part of this agreement?> In e-Week (Dec 15, 2003 pg 8) an article mentioned that Windows 98, sql
> server 7.0 and a number of versions of office 2000 are scheduled to be
> retired by Dec 23 as part of the agreement with Sun over the Java lawsuit.
I believe there are certain products that will no longer be available, e.g.
to download from the MSDN Subscriber Downloads site. But that does not mean
the product is "retired" depending on how you define "retired"; it will
still follow its product life cycle. For example, according to
http://support.microsoft.com/default.aspx?scid=fh;[ln];LifeSrvr
SQL Server 7.0 will "die," in different senses, on 12/31/2005, and
12/31/2007.
Here is a snippet from an announcement to MSDN subscribers, which highlights
the other products which will no longer be available directly:
> Due to a settlement agreement reached in January 2001, the following
> products are being phased out and will no longer available to customers
> through MSDN Subscriber Downloads or other channels at Microsoft. These
> products will be removed from MSDN Subscriber Downloads as of December
15th,
> 2003.
> Office XP Developer
> Visio 2000
> BackOffice Server 2000
> Office 2000 Developer
> Office 2000 Tools
> Office 2000 Multilingual
> Office 2000 Premium SR-1
> Office 2000 Service Pack 2
> Outlook 2000
> Project 2000
> SQL Server 7
> SQL Server 7 Service Pack 3
> Embedded Visual Tools 3.0
> Visual Studio 6 MSDE
> IE 5.5
> MapPoint 2002
> Visual Studio 6.0 SP3 and SP5
> Windows 98
> Windows 98 Y2K
> Windows 98 Resource Kit
> Windows 98 SP1 (all win98 except SE)
> Windows NT 4.0
> ISA Server 2000
> Visual Basic for (Alpha Systems)
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

is oracle 10g really oriented for grid computing?

Hello all, I known this is a SQL Server forum, but some people maybe have worked with oracle and can help me.

Microsoft's article "http://www.microsoft.com/sql/prodinfo/compare/oracle/mythandreality.mspx :"

reads as follows:

"Oracle's purported Grid enablement in 10g is based on its Oracle Real Application Clusters (RAC) technology that is no more than a local cluster. RAC is a local cluster of computers with no geographic distribution capabilities. This marketing campaign relabeled existing features to exploit current industry trends. "

My question is how can I support the above paragraph? I would like to known more reasons about why oracle grid is a local cluster instead of grid computring oriented.

Thanks in advance.

Hernán.

Hernan,

RAC is just like SQL Clustering. I don't think it like electtricity natrional grid

RAC is also a new name for Oracle Parallel Server which has been around for a bit.

Jag