Data Warehouse Vendor
Hello there, I have a question concerning the implementation of a data warehouse in a confectionary company by a vendor that is specialized in Banking industy "data warehouse". My question is; What are the impacts of such an implementation,

Data Mart Does Not Equal Data Warehouse
For an unexplained reason, the 27-Dec-2011 issue of Information Management Daily included a link to Bill Inmon's May 1998 article, "Data Mart Does Not Equal Data Warehouse." I posted the following comment. You have built a straw man data mart concep

NDS to DDS Design Questions
Hello Everyone, I am currently working on a Data Warehousing project and I am stuck on how to transform my data from my NDS to my DDS (mainly how to structure my DDS to hold the data from my NDS). The basic gist of the project is that I have three sets

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,

LA, L0, L1, L2 Data Warehouse Architecture
Hi, Just need your opinion about the following data warehouse architecture for a bank that was implemented by a Vendor (using the best practices in DW development and lifecycle) There is nobody in-house that has any data warehousing knowledge, until

WAREHOUSE SALE
Pureen Stock Clearance 12-13-apr-pureen-stock-clearance Products Offered - TO BE CONFIRMED Baby Diapers Baby Apparels Baby Toiletries Baby Accessories INCO Adult Diapers Adult Toiletries Sanitary Pads Maternity Pads Kids

Including flat files in the data warehouse
We are struggling with adopting a new feature into our data warehouse to address certain requirements. Background Currently, a robust BI solution exists using a presentation layer and star schema data model that meets the reporting needs for a

Should a data warehouse be the reporting database?
I have developed a data warehouse for our company that includes an accumulating snapshot for an application process very similar to Chapter 12, "Education" in "The Data Warehouse Toolkit" (Second Edition). The intention was to create BI on the pipeline,

History tracking in a CRM data warehouse
Hi. I've been reading these forums for a while now, but registered specifically to see what kind of responses I could get to a problem we're having. I work at a company with in-house expertise in data warehousing or dimensional modeling (you folks

Building data warehouse from scratch.. Need some advice.
Hi Folks, Currently my job is to build a data warehouse. Business is using crystal reports to generate reports from the production database(ODS). Now we want to build a data warehouse and use OBIEE OR COGNOS to generate the reports from the data

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

AuditTableProcessing Question from Microsoft Data Warehouse Toolkit. Audit Dimension
In this book, the authors recommend 3 tables for an auditing. AuditPkgExecution AuditTableProcessing AuditDimension The second table gets a new row for each table that is manipulated in a package. It consists of columns like ExtractRowCount,

differences between the three main types of data warehouse usage
1.what are the differences between the three main types of data warehouse usage ? 2.How can we construct spatial data warehouse? describe types of dimension and types of measures for creating spatial data cube?

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,

Preperaing a plane for Data warehouse and BI Tool projects
Hi All, I am preparing plan of DW and BI project . I have started with preparing the Business Requirements and BI tools requirements and I am almost completed with these tasks .Project is approved and budgeted . What are the steps that a vendors will