Master Data and Dimension location

Conformed Dimension Processing Multiple Data Marts

Rookie question. We have 8 conformed dimensions and we are on our 4th data mart using some of these 8 conformed dimensions. We build the conformed dimensions once every night because the client wants to complete full refresh only. The client has

Conforming Dimensions - Standardising, De-duplicating and Suvivorship

Hi, I'm currently reading the DW ETL toolkit, which seems to have some excellent ideas. However, as it doesn't come with any downloads (e.g example SSIS packages) - I'm struggling to understand a few things. If anyone can answer the following it would

Model available time per day in timesheet data warehouse: fact or dimension or neither?

Hi I am new to data warehousing and related subjects and as a first project I am busy analyzing our timesheet data. I would like some design ideas for the following problem: I need to compare each consultants weekly (and monthly and annual) utilization,

Customer Dimension

I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship

Master Data Management

Hi All, I think more organizations (with disparate systems) are beginning to realize the need to address the issue of having a standardize master data repository before embarking on a DW project. Different vendors have different ideas about implementin

Android Location API

Hi, Android Location API Android supports location-based services, as you'd expect from any modern mobile OS. In Android, LocationManager is responsible for handling this. To get the location manager, we ask the context to getSystemService() for

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Dimension Design with Multiple Data Sources (ORACLE and SQL Server)

Hi All. We have a client that is currently migrating from a legacy SQL Server (6.5) based ERP to Oracle e-Business Suite. The old legacy system was distributed in both application and database, however the application and database structure was (almost

FREE DEBIT MASTER CARD ON A REAL PAYING PTC!

Dear all I will talk About NewBuxIndia.com Its running successfully with help of all well know ledged members and advertisers.NewBuxIndia.Com never turns to scam but its reaches worlds No.1 PTC company position within short time of period its 100%

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:

Bridge Table and Customer Hierarchy

Does anyone know of a good detailed reference that discusses populating and maintaining customer hierarchy type bridge tables? The only decent resource I've found is the "The Data Warehouse ETL Tool Kit", but it only briefly shows an example on

What's the general age range of Elbow fans?

I know it doesn't matter really but I get so much grief off of people when I talk about Elbow, especially my friends who ususally say things along the lines of "they're crap" and "how can you listen to them they're boring and