Clay Rehm

Clay Rehm, CCP, PMP, is president of Rehm Technology (www.rehmtech.com), a consulting firm specializing in data integration solutions. Rehm provides hands-on expertise in project management, assessments, methodologies, data modeling, database design, metadata and systems analysis, design and development. He has worked in multiple platforms and his experience spans operational and data warehouse environments. Rehm is a technical book editor and is a co-author of the book, Impossible Data Warehouse Situations with Solutions from the Experts. In addition, he is a Certified Computing Professional (CCP), a certified Project Management Professional (PMP), holds a Bachelors of Science degree in Computer Science and a Masters Degree in Software Engineering from Carroll College. He can be reached at clay.rehm@rehmtech.com.

Recent Stories From this Author

Please give some suggestions to prepare an estimation effort for our ETL process.
October 1, 2007

How can one show intermediate deliverables/results to the business uses/sponsors?
October 1, 2007

How do you decide on the roles and responsibilities of operational or analytical reporting teams?
August 1, 2007

Could you recommend a review process for the logical model of our pilot data warehouse?
May 1, 2007

Are there any standard formats to document (or rather describe) the reports we generate from our DW?
March 1, 2007

We are going to change the numbering format for our customers for database across the organization. What should we consider before beginning the project?
March 1, 2007

What is the best data modeling approach for a staging area?
February 1, 2007

What are the best methodologies for testing data integration?
February 1, 2007

Are there any industry standards or best practices regarding how to handle vendor solutions specifically pertaining to conformation to an organization's information architecture standards?
February 1, 2007

How do other companies vet report requests from internal customers when rolling out the DW?
February 1, 2007

What factors should be considered and what are the risks of bringing an outsourced data warehouse back in house?
February 1, 2007

When designing a sales/marketing data mart, are there some standard performance metrics questions I can ask company executives?
November 9, 2006

How can I convince management to allocate resources for data quality?
November 9, 2006

Would you recommend deleting inconsistent data in our sources?
November 9, 2006

Do you see service-oriented architecture reducing the need for the data warehouse?
October 2, 2006

How is an information warehouse project different than a typical project for a transaction system?
October 2, 2006

What is the best way to test a data warehouse?
October 2, 2006

What is the purpose and role of dimensional modeling during data warehouse development process?
October 2, 2006

When consolidating two data warehouses, is it better to create a unique logical enterprise data model or use master data management and a service-oriented architecture to enable query, reporting and analysis as a service?
September 5, 2006

What certification will help me develop a profession in data mining?
September 5, 2006

Are there any tradeoffs between stability versus flexibility during data warehouse design?
September 5, 2006

Ask the Experts
August 25, 2006 A sample of questions that our panel of experts receives and responds to.

How do we evolve our current business intelligence infrastructure to support operational business intelligence
August 1, 2006

Do you know of studies that have been conducted or resources that might assist me in selection of database types for establishing a supporting framework for business intelligence?
August 1, 2006

Are there any good resources to assist in writing a business case for a customer data integration project or data warehousing project?
August 1, 2006

Ask the Experts
July 28, 2006 How can we meet all end-user requests for the enterprise data warehouse?

In building fact tables, what is the best practice for refreshing the data?
July 10, 2006

What are some best practices for validating data in staging tables after the ETL process has moved the data from the source to the warehouse staging tables?
July 10, 2006

How can we meet all end-user requests for the enterprise data warehouse?
July 10, 2006

Would you advocate a business rules enforced enterprise repository (ER) structure first, then a data mart for your source reports and then having the ER serve as a drill-down repository?
July 10, 2006

Why can't you experts agree on terminology?
June 13, 2006

Should the size of a company affect the need for a decision support system, a data warehouse, and an expert system to improve its sales figures and profitability?
June 13, 2006

Can you help me with some resources to prepare a standard approach for requirements definition and analysis for BI projects?
June 13, 2006

Ask the Experts
May 26, 2006 What is the current state of data warehousing and data mining?

Ask the Experts
May 19, 2006 Should knowledge made available through the use of data warehouses be disseminated to all employees in the organization?

Should we load null values into the data warehouse?
May 11, 2006

When modeling a new data warehouse, Do I put each hierarchy into one table, or do I break each hierarchy into separate tables?
May 11, 2006

Do you feel that knowledge made available through the use of data warehouses should be disseminated to all employees in the organization?
May 11, 2006

Please provide a role-description for a generic power user and his business counterpart.
May 11, 2006

Ask the Experts
April 7, 2006 This is a sample of the questions asked of and answered by our illustrious panel of experts.

After almost completing the first iteration of our data warehouse base facts and dimensions, is it reasonable to convert to an ETL tool instead of using templates to assure consistency and accuracy?
March 5, 2006

How would you generate a report that shows non-events in a fact table?
February 7, 2006

What is the relevance of a work breakdown structure in a data warehouse project?
January 3, 2006

Please help explain the 1) urgency of need and 2) elimination of risk for building a data warehouse.
January 3, 2006

What roadmap should I use for an insurance system data warehouse?
January 3, 2006

I am interested in roles/responsibilities, reporting structure, development vs. run model support of a successful data warehousing organization.
July 7, 2005

Can we implement data marts without implementing a data warehouse? What is the difference between data warehousing and data marts?
July 7, 2005

One of our customers outsourced their data warehouse. Now they want to bring it back in house. What all factors should be considered and what are the risks?
July 7, 2005

Are there any articles or white papers regarding the definition of reporting?
July 7, 2005

How could I train to be a good data warehouse business analyst?
June 8, 2005

How do you justify the benefits of the data quality to small businesses, given that larger companies don't really want to know about the quality of their data?
June 8, 2005

Which set of skills would be more pertinent for a data quality and support team leader, a technical skill or a business related skill?
June 8, 2005

What are some of the concerns we should be aware of in integrated planning?
May 2, 2005

Would you advise creating a junk dimension for a single flag? Also, when is it a good idea to create a junk dimension table?
May 2, 2005

Do you know of any studies that are available on current best practices concerning data architecture methodologies and approaches?
March 1, 2005 I am from a Federal Agency, Veteran's Administration. (VA). Our office, is initiating a project to standardize data at the...

Since hardware is relatively inexpensive, does my company have to worry about performance?
February 4, 2005 Since hardware is relatively inexpensive, does my company have to worry about performance? Can't we just throw more hardware...

What recommendations do you have for a training program fro 500-700 end users?
February 4, 2005 Our organization expects to train between 500 and 700 end users this year. What recommendations do you have for our training...

Can you point me in the direction of any white papers comparing the pros and cons of selecting a BI tool?
February 4, 2005 Can you point me in the direction of any white papers comparing the pros and cons of selecting a BI tool? I'm looking...

Is it legitimate to capitalize our data warehouse instead of expensing it?
February 4, 2005 I've heard some discussion about capitalizing our data warehouse rather than expensing it. This means the data warehouse would...

We are building a data warehouse with many source systems that provide data feeds.
February 4, 2005 We are building a data warehouse with many source systems that provide data feeds. In order to reduce the volume of data, we...

We are migrating from one data warehouse to a new one.
December 13, 2004 We are migrating from one data warehouse to a new one. Which questions need to be asked to perform a technical analysis of...

In an EDW architecture where data is consolidated and stored into a corporate data marts, how does the notion of conformed dimensions fit it?
December 13, 2004 In an EDW architecture where data is consolidated and stored into a corporate physical third normal form (3 NF) database and...

We are in the beginning stages of reengineering our enterprise.
December 13, 2004 We are in the beginning stages of reengineering our enterprise. We are looking for a comprehensive solution that will allow...

Can agile development methodologies apply to BI projects and if so what are the main pitfalls to watch out for in using such techniques?
December 13, 2004 Can agile development methodologies apply to BI projects and if so what are the main pitfalls to watch out for in using such...

We are extracting data from a legacy system that has summary data in it that we will need in the DW, should we re-derive these counts as functions of ETL to ensure accuracy?
November 1, 2004 We are extracting data from a legacy system that has summary data in it that we will need in the DW, assuming that the legacy...

Are there any best practices around how to keep enhancement data for marketing campaigns?
October 14, 2004 Our company designs databases to store campaign information. Most recently, we've been asked to keep data appends information...

How do 3NF and 1NF compare and contrast in VLDB? What advantage does the 3NF design have for a VLDB?
October 14, 2004 How do 3NF and 1NF compare and contrast in VLDB? What advantage does the 3NF design have for a VLDB?

Would you interview top executives separately or as a group for the collection of business requirements via interviews?
October 14, 2004 Would you interview top executives (CEO, COO, CFO), vice presidents and directors of functional areas separately or as a group...

We have a data consolidation system which takes transactions from multiple systems and consolidate and enriches it with contextual information and publishes the same to the downstream consumer systems.
September 8, 2004 We have a data consolidation system which takes transactions from multiple systems and consolidate and enriches it with...

How do you think RFID will affect the data warehousing space?
September 8, 2004 How do you think RFID will affect the data warehousing space?

We are in the planning stages of implementing a managed data warehouse.
September 8, 2004 We are in the planning stages of implementing a managed data warehouse. The current solution is an Oracle database which feeds...

We about to establish a new IT section, using Oracle9i with a UNIX operating system.
September 8, 2004 We about to establish a new IT section, using Oracle9i with a UNIX operating system. Do you think it is better to purchase two...

I have several years in QA and testing of software and am now working on my first data warehouse assignment.
August 13, 2004 I have several years in QA and testing of software and am now working on my first data warehouse assignment. I am having...

We want to build a management information center to manage the enterprise data warehouse (EDW) which will include business requirement management, statistical reporting, data standards and EDW management.
August 13, 2004 We want to build a management information center to manage the enterprise data warehouse (EDW) which will include business...

I recently joined the company as a DW data modeler in the production support group.
August 13, 2004 I recently joined the company as a DW data modeler in the production support group. The DW is large and was partially...

It has been suggested that we can skip user acceptance testing of the Dimension tables in order to speed up implementation.
July 8, 2004 It has been suggested that we can skip user acceptance testing of the Dimension tables in order to speed up implementation....

For an aggregated fact table which requires its data to be dimensioned by gender and age (in years), is there any benefit in creating these as dimensions at all even if it may help in cross fact analysis or not to bother as the gender and age values would be the same as the dimensional key values (i.e., age_key 16 for 16-year-olds)?
July 8, 2004 For an aggregated fact table which requires its data to be dimensioned by gender and age (in years), is there any benefit in...

I am looking for information on evaluating the success or failure of a data warehouse after implementation from a business point of view.
July 8, 2004 I am looking for information on evaluating the success or failure of a data warehouse after implementation from a business...

I'm being asked to add a "deprecator" indicator to my code tables to indicate when a valid value is no longer used.
July 8, 2004 I'm being asked to add a "deprecator" indicator to my code tables to indicate when a valid value is no longer used. This...

Any time I get to a data related project I have a choice of ETL tool vs.homegrown solution.
June 10, 2004 Any time I get to a data related project I have a choice of ETL tool vs. homegrown solution. Over the years I have created...

It's always scary to trot out one's core beliefs in front of the pros, but I need to hear your constructive criticism.
June 10, 2004 It's always scary to trot out one's core beliefs in front of the pros, but I need to hear your constructive criticism. The...

I am working on structuring a data system for a German bank that needs a data warehouse that will allow access by different departments in the bank.
June 10, 2004 I am working on structuring a data system for a German bank that needs a data warehouse that will allow access by different...

Have you ever seen UML Use Cases used as a mechanism of modeling a data warehouse functionality? Currently the DW is modeled using dimensional modeling techniques.
June 10, 2004 Have you ever seen UML Use Cases used as a mechanism of modeling a data warehouse functionality? Currently the DW is modeled...

I am currently responsible for a large MOLAP environment with lots of users and I am now responsible for taking over a large relational data warehouse.
June 10, 2004 I am currently responsible for a large MOLAP environment with lots of users and I am now responsible for taking over a large...

Can you tell me how to distinguish reporting that is done from an OLTP system vs. reporting that is done from an ODS?
May 7, 2004 Can you tell me how to distinguish reporting that is done from an OLTP system vs. reporting that is done from an ODS? We...

What factors should an organization consider when determining how often to "refresh" (update) its data warehouse?
May 7, 2004 What factors should an organization consider when determining how often to "refresh" (update) its data warehouse? Is it...

I've recently hired on to administer and manage a previously designed data warehouse.
May 7, 2004 I've recently hired on to administer and manage a previously designed data warehouse. To my surprise, the active physical...

I am preparing a document for effort estimation for data warehousing projects.
April 27, 2004 I am preparing a document for effort estimation for data warehousing projects. Currently we are using WBS (work breakdown...

I have a question on best practices to be used in designing a data warehouse.
April 27, 2004 I have a question on best practices to be used in designing a data warehouse. Assuming the data warehouse requires both an...

I have come across two approaches/practices in building data warehouses.
April 27, 2004 I have come across two approaches/practices in building data warehouses. One is constructing a data warehouse at the...

I will be extracting data from SAPR/3 and flat files and loading into my SAP-BW system.
April 27, 2004 I will be extracting data from SAPR/3 and flat files and loading into my SAP-BW system. How do I go about evaluating ETL...

How do you handle the dimension key in a fact table when a row in the fact table does not relate to one of the dimension tables?
March 4, 2004 How do you handle the dimension key in a fact table when a row in the fact table does not relate to one of the dimension...

We can have a staging area between extract and transform or we can have staging area between transform and load.
March 4, 2004 We can have a staging area between extract and transform or we can have staging area between transform and load. I would...

I am familiar with data modeling, but now I知 being asked to reengineer or build new applications running on my databases and data warehouses.
March 4, 2004 I am familiar with data modeling, but now I知 being asked to reengineer or build new applications running on my databases...

I am looking for definitions of business and executive sponsors as this functions retain to an information warehouse.
March 4, 2004 I am looking for definitions of business and executive sponsors as this function pertains to an information warehouse....

I am working with a client that is currently enforcing a standard that does not allow direct query access to data mart dimensions and fact tables.
February 4, 2004 I am working with a client that is currently enforcing a standard that does not allow direct query access to data mart...

I am a DBA, new to data warehouse concepts and would appreciate if you could reply to my questions concerning issues of architecture as I prepare to implement a one terabyte warehouse.
February 4, 2004 I am a DBA, new to data warehouse concepts and would appreciate if you could reply to my questions concerning issues of...

I have to write a paper about problems with data warehouse implementation especially the initiation phase.
February 4, 2004 I have to write a paper about problems with data warehouse implementation especially the initiation phase. Please give me...

I have been given a task to develop a data warehouse/star schema for a leasing/mortgage business.
February 4, 2004 I have been given a task to develop a data warehouse/star schema for a leasing/mortgage business. Most of the star...

We are in the process of evaluating several EBIS (enterprise business intelligence solutions).
January 8, 2004 We are in the process of evaluating several EBIS (enterprise business intelligence solutions). We have limited IT resources...

What is the third normal form of bookSBN, bookTitle, FirstAuthor, Publisher, PubStreet, PupCity, PubContact,Pages, Price?
January 8, 2004 What is the third normal form of bookSBN, bookTitle, FirstAuthor, Publisher, PubStreet, PupCity, PubContact,Pages, Price?

We have six offices worldwide where Clarify is being used.
January 8, 2004 We have six offices worldwide where Clarify is being used. Each has a separate Clarify implementation and the databases...

What would be considered data management best practices?
January 8, 2004 What would be considered data management best practices?

Can a single data staging area serve two masters, operational (ODS) and analytic (data warehouse)?
December 9, 2003 Can a single data staging area serve two masters, operational (ODS) and analytic (data warehouse)? Is a single data...

What is a degenerate dimension and how is it used
December 9, 2003 What is a degenerate dimension and how is it used?

I'm trying to persuade management on the importance of meta data.
December 9, 2003 I'm trying to persuade management on the importance of meta data. Can someone please provide me pointers on this matter?...

Should I use a work breakdown structure in a data warehouse project?
December 9, 2003 Should I use a work breakdown structure in a data warehouse project?

What are the responsibilities of a data warehouse project manager?
December 9, 2003 What are the responsibilities of a data warehouse project manager?

What are the major risk factors in a data warehouse project implementation?
December 9, 2003 What are the major risk factors in a data warehouse project implementation? Do you have any case studies for these risk...

I have a client that has a data warehouse with Sun servers, Hitachi storage and an Oracle database.
December 9, 2003 I have a client that has a data warehouse with Sun servers, Hitachi storage and an Oracle database. It seems that there...

When should I use a bitmappped index?
December 9, 2003 When should I use a bitmappped index?

I am a Ph.D student in engineering management at the George Washington University.
November 5, 2003 I am a Ph.D student in engineering management at the George Washington University. My dissertation topic is related to...

Is there any methodology to design and implement a data warehouse?
November 5, 2003 Is there any methodology to design and implement a data warehouse?

I am working in the marketing department of an Iranian steel manufacturing company.
November 5, 2003 I am working in the marketing department of an Iranian steel manufacturing company so I know the industry well but I need...

What are the various phases in implementing a data warehouse solution?
November 5, 2003 What are the various phases in implementing a data warehouse solution? What are the various technologies / tools...

What are the pros and cons of horizontal database partitioning and please focus on the scenario when the database is part of a package (e.g., Siebel) which contains meta data.
November 5, 2003 What are the pros and cons of horizontal database partitioning and please focus on the scenario when the database is part...

How does one go about implementing a data warehouse for banks?
November 5, 2003 How does one go about implementing a data warehouse for banks? Are there any case studies available for implementation...

Is a data mart defined by its size or is it defined by the specific business process it supports?
October 9, 2003 Is a data mart defined by its size or is it defined by the specific business process it supports?

I知 not sure if I知 going in the right direction with my data warehouse, data marts, cubes and business intelligence development.
October 9, 2003 I知 not sure if I知 going in the right direction with my data warehouse, data marts, cubes and business intelligence...

My question is in the realm of operational reporting.
October 9, 2003 My question is in the realm of operational reporting. My client (a state government) does not want the expenses of an...

How should I consider the integration of business intelligence systems and business performance management and what are the best ways to analyze these types of systems?
October 9, 2003 How should I consider the integration of business intelligence systems and business performance management and what are the...

What is the difference between the terms "business intelligence" and "data warehousing?"
August 22, 2003 What is the difference between the terms "business intelligence" and "data warehousing?" People seem to be using these...

If a piece of information traverses several applications before placement in the DW is the data quality of that information more in question than data that arrives directly from the operational source?
August 22, 2003 If a piece of information traverses several applications before placement in the DW is the data quality of that information...

What is the best RDBMS (Teradata, Oracle or DB2) for data warehousing based on performance and size?
August 22, 2003 What is the best RDBMS (Teradata, Oracle or DB2) for data warehousing based on performance and size? We are looking at a...

If a given DW field/element/column can be updated from several operational sources, it would seem that the risk of erroneous data is heightened.
August 22, 2003 If a given DW field/element/column can be updated from several operational sources, it would seem that the risk of...

We are currently looking for a best-in-class, pure Web-based BI tool for reporting, ad hoc and analysis needs.
August 22, 2003 We are currently looking for a best-in-class, pure Web-based BI tool for reporting, ad hoc and analysis needs. Any...

Can you suggest good material such as books, research papers and Web resources that can be a guide for writing professional grade data warehouse business requirements?
August 22, 2003 Can you suggest good material such as books, research papers and Web resources that can be a guide for writing...

I'm a JAVA developer involved in developing a data warehouse project.
August 22, 2003 I'm a JAVA developer involved in developing a data warehouse project. What are the processes involved in developing a...

I would like to know about star schemas with multiple fact tables.
August 4, 2003 I would like to know about star schemas with multiple fact tables. What are the advantages of having multiple fact star...

In the insurance industry there are a lot of calculations that could be performed on the premium amounts.
August 4, 2003

I read about versioning of meta data.
August 4, 2003 I read about versioning of meta data. I want to implement it in the database system, where I'm going to keep some...

I am currently managing the feasibility study phase of a data warehousing project.
August 4, 2003 I am currently managing the feasibility study phase of a data warehousing project. However I am currently having a tough...

My group has the responsibility for defining the business requirements for front-end (customer interface) and back-end (processing) operations for a banking operation.
August 4, 2003 My group has the responsibility for defining the business requirements for front-end (customer interface) and back-end...

If someone were to venture into the BI world, what would be a logical starting place?
June 4, 2003 If someone were to venture into the BI world (say some one with 10 years of experience in the IT field on legacy...

We are planning a multinational data warehouse.
June 4, 2003 We are planning a multinational data warehouse. This issue raises a number of interesting questions: How should we...

Are there any articles, books, or papers on maintenance issues for data warehousing systems?
June 4, 2003 Are there any articles, books, or papers on maintenance issues for data warehousing systems? I知 looking for the...

Which are the ETL tools that are generally recommended to be used with MicroStrategy?
June 4, 2003 Which are the ETL tools that are generally recommended to be used with MicroStrategy?

I have been told to identify all objects relating to a customer in a data warehouse and a data mart.
May 2, 2003 I have been told to identify all objects relating to a customer in a data warehouse and a data mart.

What kind of software can be used in a customer alert system?
April 2, 2003 What kind of software can be used in a customer alert system?

What is a DOLAP?
April 2, 2003 What is a DOLAP?

Please give me a definition of an enterprise-wide solution.
April 2, 2003 Please give me a definition of an enterprise-wide solution. What are the advantages and disadvantages of using this method?

We met with one of the BI vendors to discuss query and reporting and multidimensional reporting.
April 2, 2003 We met with one of the BI vendors to discuss query and reporting and multidimensional reporting. As the discussion...

I'm in charge of our data warehouse and one of my colleagues suggested we look into purchasing a job scheduler to handle file transfers, job dependencies, etc.
April 2, 2003 I'm in charge of our data warehouse and one of my colleagues suggested we look into purchasing a job scheduler to handle...

Are there any industry standards or best practices on how to handle vendor solutions specifically pertaining to conforming to information architecture standards.
April 2, 2003 Are there any industry standards or best practices on how to handle vendor solutions specifically pertaining to conforming...

I'm a data warehouse project manager.
March 13, 2003 I'm a data warehouse project manager. My team is understaffed. I've read and attended conferences where it's made clear to...

I have trouble selling the data warehouse to management.
March 13, 2003 I have trouble selling the data warehouse to management. They believe that the minimal reporting capabilities they have...

Are there any Web sites or institutions that give the pros and cons for each BI tool? And are there any selection criteria?
March 13, 2003 Are there any Web sites or institutions that give the pros and cons for each BI tool? And are there any selection criteria?

My customer information is spread over multiple systems on different platforms.
February 3, 2003 My customer information is spread over multiple systems on different platforms (Windows, UNIX, mainframe). The requirement...

We are involved with a DW strategy and planning a CRM strategy.
February 3, 2003 We are involved with a DW strategy and planning a CRM strategy. The company needs information now, and we can't wait for...

I am new to data warehousing.
February 3, 2003 I am new to data warehousing. I am working on a DW project. The role of my team is to do system testing for the project....

I am currently involved with a start-up for-profit graduate and undergraduate educational project.
February 3, 2003 I am currently involved with a start-up for-profit graduate and undergraduate educational project but I want part of the...

The role of a business analyst for a data warehouse project is often conflicting and confusing.
January 13, 2003 The role of a business analyst for a data warehouse project is often conflicting and confusing. Can you establish how a...

We are (were) primarily a mainframe shop that has, in the past couple of years, moved first to Oracle and most recently to SQL Server databases.
January 13, 2003 We are (were) primarily a mainframe shop that has, in the past couple of years, moved first to Oracle and most recently to...

How do I get project managers (business side/end users) to take ownership in a data warehousing initiative?
January 13, 2003 How do I get project managers (business side/end users) to take ownership in a data warehousing initiative?

I am currently a student at college. We have an assignment to do on CRM.
January 13, 2003 I am currently a student at college. We have an assignment to do on CRM. We have to develop a CRM and convince the board...

We are working with a data warehouse project where we extract data from the source (ETL) and create fact tables and dimensions depending on them.
January 13, 2003 We are working with a data warehouse project where we extract data from the source (ETL) and create fact tables and...

We would like to create a corporate information management policy that will underpin future BI and data quality efforts and act as a executive-level
January 13, 2003 We would like to create a corporate information management policy that will underpin future BI and data quality efforts...

As part of a corporate-wide, one-instance implementation of ERP (SAP R/3) we are rethinking master data maintenance and data quality.
January 13, 2003 As part of a corporate-wide, one-instance implementation of ERP (SAP R/3) we are rethinking master data maintenance and...

We are trying to create a policy on information reporting that would identify the types of reports that should come from our DW vs. those that should come from our operational systems.
January 13, 2003 We are trying to create a policy on information reporting that would identify the types of reports that should come from...

I would like to know how to make effort estimations for ETL, query and reporting, and data mining.
December 2, 2002 I would like to know how to make effort estimations for ETL, query and reporting, and data mining. Are there any standard...

Can we and should we adopt different data modeling schemas during the extraction, transformation and staging method?
December 2, 2002 Can we and should we adopt different data modeling schemas during the extraction, transformation and staging method? What...

Do you suggest surrogate keys in data marts and/or EDW solutions?
December 2, 2002 Do you suggest surrogate keys in data marts and/or EDW solutions?

Assuming that the applications and databases are on separate machines, what is the current thinking on where the data warehouse database should reside?
December 2, 2002 Assuming that the applications and databases are on separate machines, what is the current thinking on where the data...

When it comes to the design technology of enterprise data warehouse (EDW), some people are insisting we use Inmon's approach of top-down methodology.
December 2, 2002 When it comes to the design technology of enterprise data warehouse (EDW), some people are insisting we use Inmon's...

If there are 10 data marts which use different schemas (some use star and the others use snowflake), will inconsistencies arise designing a data warehouse using a bottom up approach?
December 2, 2002 If there are 10 data marts which use different schemas (some use star and the others use snowflake), will inconsistencies...

It seems that there is very little academic research done in the data warehouse area in spite of the need for this by the business community.
December 2, 2002 It seems that there is very little academic research done in the data warehouse area in spite of the need for this by the...

My company is looking for a BI intelligence suite to integrate with our CRM Web-based solution.
December 2, 2002 My company is looking for a BI intelligence suite to integrate with our CRM Web-based solution (the RDBMS is MS SQL Server...

What is the industry standard benchmark for data warehouse customer usage?
December 2, 2002 What is the industry standard benchmark for data warehouse customer usage? I am particularly interested in comparing the...

I want to know how to estimate the total project cost to implement a data warehouse.
December 2, 2002 I want to know how to estimate the total project cost to implement a data warehouse. Are there any tools available to...

I am providing information for a proof of concept (my first time) on an ETL tool for a major data conversion project.
December 2, 2002 I am providing information for a proof of concept (my first time) on an ETL tool for a major data conversion project. Could...

What kind of tools can you recommend to perform data auditing and quality analysis?
December 2, 2002 What kind of tools can you recommend to perform data auditing and quality analysis?

My company is currently starting an enterprise data warehouse project with an end result of ultimately feeding all of the back-end systems including our General Ledger system.
November 5, 2002 My company is currently starting an enterprise data warehouse project with an end result of ultimately feeding all of the...

We are in the process of building an insurance data warehouse.
November 5, 2002 We are in the process of building an insurance data warehouse. Some of the people involved in this project are thinking...

We are using MicroStrategy7 as our reporting tool against our data warehouse which is DB2 on an IBM OS/390 mainframe.
November 5, 2002 We are using MicroStrategy7 as our reporting tool against our data warehouse which is DB2 on an IBM OS/390 mainframe. We...

What strategy do you suggest to update dimensions using flat files as a source that do not have a time stamp?
November 5, 2002 What strategy do you suggest to update dimensions using flat files as a source that do not have a time stamp? I've tried to...

We are doing an OLTP project for our client, but they want OLAP capabilities for reporting.
November 5, 2002 We are doing an OLTP project for our client, but they want OLAP capabilities for reporting. Since these are such opposite...

My duties as a business intelligence analyst are to implement a standard reporting process in the company, develop standards for best practices for reporting (using Oracle tools) and market.
November 5, 2002 My duties as a business intelligence analyst are to implement a standard reporting process in the company, develop standards...

Can you tell me where to find a good, comprehensive
October 3, 2002 Can you tell me where to find a good, comprehensive "template" for a data requirements document?

I have been challenged by a big manufacturing company, which consists of dozens of individual plants (through acquisitions but still function independently with their own data centers and some with their own DW) to build an enterprise data warehouse.
October 3, 2002 I have been challenged by a big manufacturing company, which consists of dozens of individual plants (through acquisitions...

In a simple star schema design for a data mart, does it matter if the relationships from the dimension tables to the fact tables are indirect relationships rather than direct relationships?
October 3, 2002 In a simple star schema design for a data mart, does it matter if the relationships from the dimension tables to the fact...

I am trying to prove a business case to demonstrate the quantifiable business benefits of implementing data standards to support our heterogeneous ERP environment.
October 3, 2002 I am trying to prove a business case to demonstrate the quantifiable business benefits of implementing data standards...

My question relates to hardware configuration for DW environments.
October 3, 2002 My question is what is "recommended" related to the hardware configuration for a "typical" production environment. In...

I am building a data mart for a P&C insurance company.
October 3, 2002 I built a dimensional model comprised of a dozen dimensions. Something about it doesn't feel right. Shouldn't I break the...

I知 building a DW/DM for an educational institution which has many campuses.
October 3, 2002 I知 building a DW/DM for an educational institution which has many campuses. I知 tasked with building a DM template that...

Industry standards state that the typical star schema will have about six dimension tables and the associated fact tables depending on grain, etc.
September 4, 2002 Industry standards state that the typical star schema will have about six dimension tables and the associated fact tables...

Are there sample documents on what to test in a data warehouse environment?
August 26, 2002 Are there sample documents on what to test in a data warehouse environment? What are some test strategies for data...

We have Oracle as our RDBMS for all the applications.
July 26, 2002 We have Oracle as our RDBMS for all the applications. Because the infrastructure exists for Notes already, they want to use...

How do I cut my warehouse costs? I need general tips to reduce my warehouse costs.
June 25, 2002 How do I cut my warehouse costs? I need general tips to reduce my warehouse costs.

Data quality is a critical issue affecting data warehouses, (DWs) yet there appears to be no sustainable solution with regard to quality input
June 5, 2002 Data quality is a critical issue affecting data warehouses, (DWs) yet there appears to be no sustainable solution with...

One subject area of our DW is about tasks of several projects.
June 5, 2002 When do we store a date in the fact table and when do we use a foreign key to a date dimension?

As PeopleSoft EPM 8.3 is a recent version and we do not have and history for its use, I would like to know what approach shall we take involving its staging and ODS schema for finance and Human Resources?
May 3, 2002 As PeopleSoft EPM 8.3 is a recent version and we do not have and history for its use, I would like to know what approach...

Do you have any suggestions for automated end-to- end testing for a data warehouse implementation?
May 3, 2002 Do you have any suggestions for automated end-to- end testing for a data warehouse implementation? If so, what level of...

Which tools and database should we select to implement a data warehoue?
May 3, 2002 We want to implement a DW. Which tools and database should we select? Please compare Teradata with ORACLE and its tools for...

Can you use one database model for OLAP and OLTP?
May 3, 2002 My company is now investigating whether you could use one database model and/or one database for both OLTP and OLAP...

Is DTS suitable as a sole ETL tool?
May 3, 2002 Is DTS (MS SQL) really suitable as the sole ETL tool when it comes to the daily operation (and support) of a data...

We can use Excel and ODBC drivers to tap into data in Access, MS-SQL, etc.
April 17, 2002 We can use Excel and ODBC drivers to tap into data in Access, MS-SQL, etc. Is it possible to do the same against mainframe DB2...

My client presently uses ETI Extract and custom-built code for many data migration projects but purchased Informatica and is planning to migrate to Informatica.
April 17, 2002 My client presently uses ETI Extract and custom-built code for many data migration projects but purchased Informatica and is...

In a data warehouse for the financial or telecom industry, the customers are of two main categories: corporate and retail.
April 17, 2002 In a data warehouse for the financial or telecom industry, the customers are of two main categories: corporate and retail....

Regarding dimensional modeling vs. OLAP modeling.
March 13, 2002 Regarding dimensional modeling vs. OLAP modeling. Should these tasks have separate titles and roles or are they one and the...

I'm not sure if I should balance my data for predictions or decision trees or not: Imagine you have 100 cases (customers).
February 7, 2002 I'm not sure if I should balance my data for predictions or decision trees or not: Imagine you have 100 cases (customers). 20...

We are implementing a balanced scorecard (BSC) application and are going to use our existing data warehouse as the source system.
February 7, 2002 We are implementing a balanced scorecard (BSC) application and are going to use our existing data warehouse as the source...

I would like to know how best to test the warehouse in ETL if we are not using any tools for ETL (everything has been written in programs)?
February 7, 2002 I would like to know how best to test the warehouse in ETL if we are not using any tools for ETL (everything has been written...

I am looking for a reporting tool with a simple report development interface.
February 7, 2002 I am looking for a reporting tool with a simple report development interface. The usual suspects (BO, Brio, Cognos) are too...

During the first meeting with one of my prospects (a large Italian tire and cable manufacturer) the IT person responsible of the DW in the company told me:
February 7, 2002 Building a fact from the product creates a big hassle when I need a product dimension to analyze other key performance...

Does it make a difference in query performance if I write tableA.colx = tableB.colY or the other way round?
June 4, 2001 Does it make a difference in query performance if I write tableA.colx = tableB.colY or the other way round? Is this...

What are the current issues and concerns with gathering requirements for a data warehouse?
June 4, 2001 What are the current issues and concerns with gathering requirements for a data warehouse? Do you have any good...

What factors should be considered at different stages of a data warehouse implementation to arrive at a size estimate for a project?
June 4, 2001 What factors should be considered at different stages of a data warehouse implementation to arrive at a size estimate for a...

My firm has been asked to perform the feasibility study for a meta data.
June 4, 2001 What questions should I ask the organization's technical stakeholders? Also, which toolsets would facilitate the...

I have been asked to compare two data warehouse products from Brio and Cognos.
April 2, 2001 I have been asked to compare two data warehouse products from Brio and Cognos. What are some of the things that I should...

Is there a widely recognized certification for data warehouse professionals? If so, what organization issues the certification?
April 2, 2001 professionals? If so, what organization issues the certification?

Could you recommend any data warehouse management classes?
April 2, 2001 Could you recommend any data warehouse management classes? I am interested in putting form behind function per my data...

During the development of a data warehouse, how far can you progress with the development effort without the identification of an end-user tool?
March 20, 2001 During the development of a data warehouse, how far can you progress with the development effort without the identification...

In planning a data warehouse, what are the possible disadvantages or advantages of choosing either DB2 or Oracle as the database structure?
March 6, 2001 In planning a data warehouse, what are the possible disadvantages or advantages of choosing either DB2 or Oracle as the...

I am looking for information on MS SQL Server 7.0.
January 12, 2001 I am looking for information on MS SQL Server 7.0. Do you know where I can find this information?

We are currently seeking to establish a reporting framework for our organization.
January 12, 2001 What is the best approach to demonstrate the benefits of a consolidated reporting framework?

What can稚 my operational reports (from my ERP system) offer me what a business intelligence system can?
January 12, 2001 What can稚 my operational reports (from my ERP system) offer me what a business intelligence system can?

What is the purpose of designing a logical data model for a data mart or warehouse?
December 13, 2000 What is the purpose of designing a logical data model for a data mart or warehouse?

What are the disadvantages of having a data warehouse in place?
December 4, 2000 Are there any disadvantages to having a data warehouse in place?

Should data be changed in the data warehouse and/or data mart making it different from the source system it came from?
December 4, 2000 Should data be changed in the data warehouse and/or data mart making it different from the source system it came from? What...

Is it possible to make data model before ERP system implementation and a data warehouse?
September 1, 2000 Is it possible to make a data model before an ERP system implementation and a data warehouse?

An operational data store (ODS) is different from data warehouse, but it is one part of data warehouse. Do you agree?
September 1, 2000 An operational data store (ODS) is different from data warehouse, but is it part of a data warehouse?

I work for a non- profit organization that is just starting to write an RFP for their membership database and redesign of their Web site.
September 1, 2000 My organization is starting to write an RFP for their membership database and redesign their Web site. I have been assigned to...

I am very keen to move into the database sector. What are the typical day-to-day tasks of a DBA?
September 1, 2000 I am very keen to move into the database sector. What are the typical day-to-day tasks of a DBA?

Twitter
Facebook
LinkedIn
Please note you must now log in with your email address and password.