Migration to Dimensional Modeling - Testing
Hello, I migrated a relational database to dimensional modeling database. I need to test that all the information in the source system is there in the target system. One technique which can be used is... - to calculate the number of records in 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

PADM 691 The Migration Reader Exploring Politics and Policies
The Migration Reader Exploring Politics and Policies By Anthony M. Messina and Gallya Lahav This book is being sold used for $24.40 at the Monroe campus bookstore. I am selling it for $15. If interested please call me at 571-247-1746. My name is

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

Data Warehouse Failure Statistics
Is there any recent study / statistics / surveys on data warehouse project pitfalls and risks ? Your help is truely appreciated. Best Regards,

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

Agile Enterprise Data Warehousing
I would really appreciate it if someone could just point me in the right direction with regards the situation I’m faced with currently. The scenario: My team was tasked with implementing a data warehouse. This has been a challenge since the

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

Managing Data warehousing Unit
I am working as data warehousing and Reporting manager. I am responsible of managing the unit and helping my Engineers in data modeling and ETL design and developing Reporting some times .I am also responsible of running any data warehousing projects

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,