Data Marts, Conformed dimensions and Data Warehouse

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

Data Warehouse Modeling

Hello there, Considering the case that i am assigned to work on, which is to decide on the most appropriate schema to be chosen for the Data Warehouse / Business intelligenece Project. First of all, i would like to know the available options for me,

Dimension Attributes and Fact attributes storing same data in multiple data marts??

Can data marts using BUS architecture store the same data but be called different names like DimChargeToDept and DimDepartment. All have the same attirbutes names different but same exact data and rows. I would rather they create a view for each

"Shared Dimensions" ... Complicates Usage of Data Warehouse??

Question about 'Shared' dimensions. I have the following shared dimensions: Dim_Shared_Status & Dim_Shared_StatusType Dim_Shared_Status contains: [Id], [StatusTypeId], [Name] Dim_Shared_StatusType contains: [Id], [Name] Now

Data Warehouse with high data availability

When a data warehouse is being updated by periodical ETL load, there could be significant performance impact on the end users' reports while the underlying tables are touched. The data becomes volatile and the query results could be different between

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

Defining technical requirements for a datawarehouse, an existing one at that

I have no experience doing requirements documentation for a data warehouse, and am hoping an experienced practitioner or two can provide some practical lessons from documenting a data warehouse. To add an extra twist, the data warehouse is already in

Request of information: Italian softwarehouse for federated Data Warehouse

Hello, I work for an Italian financial Company that needs to reorganize the current reporting system (mainly based on Business Objects), which is made of many Data Warehouses and Datamarts in Oracle and SAP/BI. I'm interested in a federated solution

How to manage Conformed dimensions

Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

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:

Playthrough 2.5 Question!

Ok, so I've completed the game on PT2 this morning. So PT2 should be PT2.5 now right? I've seen pictures on here of level 60 drifters and on my friends PT2.5 Knoxx was level 61 and everything else was level 60. Drifters are level 55 on mine, Knoxx Is

ETL from Oracle to SQL Server 2008 Data Warehouse

Hello, Our data warehouse runs on SQL 2008 servers. One of the transactions systems we have runs on an Oracle database and managed by a separate team. What are the recommended methods to extract source data from an Oracle database and loading to a