Data Warehouse for survey data
Hi All, Working with a company which uses Salesforce.com heavily. They have a large number of custom fields, and great volatility in them - frequently adding and deleting them when they cease being relevant (They collect survey data for their clients).

SOA and Data Warehousing
Hello everyone.... I need your help here. I am working on some DW related roadmaps. I am stuck on role SOA(Service Oriented Architecture) is going to play in Data Warehousing ETL in- particular and BI in-general. Your comments on above mentioned are

Looking for a Data Architect
My company is seeking a Senior Data Architect. We are a Kimball shop, but we also build & support ODSes as well. Please send my a PM if interested! Here is description: As a member of our technology team, you will contribute to the

Data mart design
Lets say I need to model Frauds. There is 2 departments handle different Frauds say (Contract and Health care). I am going to model this in MD (fact, dimension). Now should I just create one Fact table(Business Process) and use say Fraud type (Contract,

Data Marts, Conformed dimensions and Data Warehouse
Hello, Can you please assist me in understanding the following. I am new to data warehouse. I'm using microsoft products to build my enterprise DW/BI 1. Do I build data marts for my enterprise DW/BI or do I iteratively build a data warehouse? I

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:

Data Warehouse Purge Strategy - HELP
I'm looking at the best way to implement a purge strategy in a dimensional model. The reason to purge is that no personal data can be kept after 4 years, but the users would still want to see counts/facts by no identifying data. For example i couldn't

Data Modeler EDW - responsibilities
Hi all, I need to describe the core responsibilities of a data modeler for an EDW in the format of responsible for developing the logical and physical design for ... Standard stuff regarding experience with 3NF, Star / Snow flake, etc. would apply,

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

How to implement a data warehousing solution for Google Analytics data?
I have click stream data such as referring url, top landing pages, top exit pages and metrics such as pageviews, number of visits, bounces all in Google Analytics. There is no database yet where all this information might be stored. I am required to

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

Data Changing Guide made by Kevin
Data Changing Guide made by Kevin Part I: Spoiler: PART I DATA.TXT REQUIRED: LF2 Data Changer Contents: I. Data.txt - Structure II. ID, Type, and File explanation III. How to insert or change a character Guides I. Data.txt -

Relational Datawarehouse
Hi, I have always understood that a Datawarehouse uses a Dimentional Model. But then i hear that there are Datawarehouses using the Relational model. My question is if the OLTP system by itself falls under the relational model, then what would the

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

Data Cleaning - replacing nulls and addresses
Hi, I need to do some data cleaning as part of a data warehouse project that I'm about to start. Some of the tasks will include some basic data cleaning (e.g. handling of nulls & replacing with a default value). Then there will be more complex