Start Schema vs Snow flake schema

Advantages Disadvantages of Star Vs. Snowflake in your DW Env. Has anyone switched from one to another & Why ?

Can anyone list the advantages and disadvantages of Star vs. Snowflake in your DW environement . And has anyone switched from one to another and why?

Large number of snowflake code tables per dimension

Ten(10) or so key dimensions(lets call them base dimensions) each has about 25 parent code tables in the 3rd normal operational source. Each code has a short and long description. In the multidimensional model If a fact table has say 3 base dimensions the

Question on symmetry in Star schema

Hi I read Kimball's Data warehouse toolkit and I came across a point that one of the advantages of having star schema is - BI / reporting tools in the market can leverage the symmetrical nature of the star schema. From what I know and I could

Flat Table vs star schema

We hear a lot of BI implementations using star schema. (with few dims snowflaked sometimes ) Why not choose a flat table with all data put together instead of a star schema? (well , this question may seem strange, but please help me out here) Few

makeing a stand for star schema design

Hi, I am new to a financial company and I was asked to model two new sources of data in the existing mortgage data mart (not too sure if you could actually call it a datamart after seeing the design), basically I was asked to create detail information

Cube Processing for Dimension Schema changes

Hi, I had a general question about how cube processing works. If my dimension schema changes (an addition of a property), will I have to do a full reprocess of all cube partitions for which that dimension was member of? Or do I only need to

how to model an event log

I am trying to model the following event data: Field1 = event date, field2 = event code, field3 = location code, field4 = customer_id, fields5 to 8 are event code specific, ie.

Dimensional Model Vs Views as Structure for BOBJ Universe

I have a fairly complex data mart (multiple fact tables: 5 at the moment and several more coming; 4 shared dimensions across the 5 facts, 26 total dimensions and several bridge tables). I used standard best practices for building the Business Objects

How do i start selenium server using python code

Hi, Iam using selenium rc python.... how do i start selenium server using python code not to start in command prompt.... please give the code

Guide : How to start with your forum

Guide : How to start with your forum. Here is a guide that will give you the steps to follow when starting a forum. 7 Steps 1- Before even creating the forum, you must know what to talk about. Indeed, you will spend time on your forum, it is

Funny comedy joke time!

We all could use a laugh now and again, so here's where to find one when you need one. If you have something funny from your fave comic that you want to share, post it here. I'll get the ball rolling with one of my favorites, the late great Bill

To Start Something New (Private, RU only. Possible lemon XD)

Sairento silently sat on the branch of what seemed a dead tree. His spiritual output seemed to have far surpassed what it used to be. He was simply staring out, not really looking at anything. His eyes were now a permanent black with golden irises. He

Battery Usage / Charging observations

The battery charging and battery usage seem to puzzle me. Today under controlled environment, I had the unit in operation. Charger attached. Waited until the Icon shows full Green, and battery state (under "spare parts") showed 100% AND fully