Looking for a Data Architect

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:

ETL Architecture

Hi My company is currently planning on building a datawarehouse. We are an oracle shop and are considering the approach for data migration from client servers to the datamart. Thoughts we have 1) Asynchronous CDC . I believe oracle now is replacing

Facts at different levels of hierarchy

Let's say I have an empoyee dimension consisting of the usual attributes describing a person, but also these two: Department and Company. Let's also say I have budget numbers for the three levels (Employee, Department, and Company). I would think tha

DW Architecture for a new setup

Ok I'm a newby to DW. I am tasked with setting up a data warehouse this year. There are a couple of things which I feel make it unique, I'll outline the plan I have come up with to accomplish this as of right now. We have 2 OLTP systems, one was from

ETL Architecture and Control Flow

Hi Folks, I am new to the forums, they look like an interesting place to discuss BI issues and troubles. So, I am not new to BI, but we have done a lot of re-architecting of the etl systems with servers being moved, wan considerations

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

Data Warehousing Vendors (Manufacturing)

Dear Sir or Madam We are a local company located in Syria, specialized in Industrial Confectionary Development (Food; Biscuit, Chocolate and Juice) The company seeks to find consultants/ vendors in order to initiate a data warehouseing project to be

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

Staging Activities

What are the common staging activities that the Kimball method recognizes? Traditionally I have used staging databases to 1) Decouple from the source-to-Data Mart for restartability 2) Consolidate multiple sources and source formats into a single

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

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

New Release Media Companion gen2 3.148

Just a small update on 3.143 New feature for Movies, support for <sortorder> tags. The field is below the Movie title, by default it is the same as the title, but xbmc will list movies alphabetically according to what is in this tag. You ca

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: