Rule based algorithm to convert an ER model to a dimensional model ...

Operational Reporting from a Dimensional Model

Having worked with various models over the years, i'm begining to think that a multi layered data model approach is best for medium and larger corporations. (see my IM model here

Question - creating a dimensional model for facility management

Hello, folks. I'd like to ask some newbie questions. I'm starting a multidimensional model for facilities management from scratch, and I'll certainly need a SPACE dimension, since it's the grain in which all the spatial information is stored in the

Logical Dimensional Model

Is there such a thing as a logical dimensional model? If you agree, how is it different than your physical dimensional model?

Need for a dimensional modeling tool?

I'd like to hear opinions from members of this group about the need for a modeling tool that's more oriented towards dimensional models. Most of us use Erwin or a similar modeling tool, which is designed for general E/R modeling (to be honest, Erwin also

Remington Model 29

Looking for Remington Model #29 shotgun. Not real common, the 4-5 I've seen were rough shape. Would like to find one decent shape and price, no polychokes or recoil pads.

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 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.

anyone use Talend for a production dimensional model build

I'm looking at Talend as they seem to be on a roll with the recent inclusion of Data Quality and Master Data Management components into their suite. Wondering what experiences anyone has had building a standard dimensionally modelled Datamart or Data

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

Converting Columns into Rows.

I have a requirement where I need to convert rows in columns. The data is quite huge there would be around 200 million records. The sample table contains only data for five months but in actual 12 months of data come in a single row and number of columns

Sandy Bridge Rig

Just built a Sandy Bridge rig with a Core i7-2600K, Asus P8P67 EVO, 8 GB G.SKILL RIPJAWS X series RAM (4GB x2), and an Asus nVidia based GTX460 graphics card. Slapped it in a Lian-Li PC-8NWX case mid-tower... and so far so good. Running only Ubuntu 10.1

RP Basketball...The Road Back To World Championship 2010

Yeng Guiao is the best to coach the next National team, I hope he will include these players: the best line-up for me: Lordy Tugade James Yap Gabe Norwood Anthony Washington Kelly Williams Jared Dillinger Jimmy Alapag Jay-jay Helterbrand Asi

Data Vault v's Dimensional Model

Seems to be a lot of interest over at LinkedIn around the DataVault model. I wondered what the thoughts were about it. When would you use it v's a Dimensional Model or even a 3NF for a data warehouse. more info here: