Michael Jennings is a recognized industry expert in enterprise information management. He has more than twenty years of information technology experience in the healthcare, telecommunications, insurance, banking, manufacturing and logistics, and human resources industries and has experience within governmental organizations. Jennings has published numerous industry columns/articles for EIM Institute, Information Management and Intelligent Enterprise magazines and others, and has been a judge for numerous awards. He speaks frequently on enterprise information management issues and practices at major industry conferences, and has been an instructor of information technology at the University of Chicago's Graham School. Jennings is a co-author of the book "Universal Meta Data Models" (2004) and a contributing author to the books "Building and Managing the Meta Data Repository" (2000) and "The DAMA Guide to the Data Management Body of Knowledge" (DAMA-DMBOK, 2009).

Meta Impact, Part 2
December 1, 2005

Meta Impact
October 1, 2005

Fuzzy Data Integration, Part 2
September 1, 2005

Fuzzy Data Integration, Part 1
August 1, 2005

Information Delivery Shortcuts, Part 3
June 1, 2005

Information Delivery Shortcuts, Part 2
May 1, 2005

Information Delivery Shortcuts, Part 1
April 1, 2005

Query Analysis of the Data Warehouse Environment
March 1, 2005

A Systematic Approach to ETL Design
February 1, 2005

Performance Impacts on the Data Warehouse Environment, Part 2
January 1, 2005

Enterprise Architecture View
December 1, 2004

Final Component of the Complete Meta Data Model
October 1, 2004

Business Rules, Business Meta Data & Data Stewardship Component of the Complete Meta Data Model
September 1, 2004

I’m intrigued by the OMG's Common Warehouse Metamodel.
August 13, 2004 I’m intrigued by the OMG's Common Warehouse Metamodel. In what areas is this model lacking? What are its main pitfalls and...

We are beginning a clean-sheet-of-paper architectural strategy for our overall reporting and BI needs.
August 13, 2004 We are beginning a clean-sheet-of-paper architectural strategy for our overall reporting and BI needs. Part of this effort...

Business Rules, Business Meta Data and Data Stewardship Component of the Complete Meta Data Model
August 1, 2004

Enterprise Architecture View
July 1, 2004

We talk a lot about ROI on data warehouse, business intelligence, etc.
June 10, 2004 We talk a lot about ROI on data warehouse, business intelligence, etc. I wonder what measures to use to calculate ROI on...

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

The Enterprise Systems Component of the Complete Meta Data Model
June 1, 2004

Interaction of the Complete Meta Data Model
May 1, 2004

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

The Complete Meta Data Repository
April 1, 2004

Information Semantics
March 1, 2004

Multifaceted Data Access in the Data Warehouse, Part 2
February 1, 2004

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

Multifaceted Data Access in the Data Warehouse, Part 1
January 1, 2004

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

Temporal Perspective, Part 2
December 1, 2003

Temporal Perspective
November 1, 2003

Enterprise Architecture View
October 1, 2003

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

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

Business Delivery for Rent, Part 2
August 1, 2003

Is there a standard that can be used as a guideline for sizing and capacity?
July 2, 2003 Is there a standard that can be used as a guideline for sizing and capacity? I’ve been reading many sources of information...

Business Delivery For Rent
July 1, 2003

What's in Your ETL Method?
June 1, 2003

How can business systems analyze customer's personalized needs?
May 2, 2003 How can business systems analyze customer's personalized needs?

An Information Delivery Framework
May 1, 2003

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

The Weakest Link, Part 3
April 1, 2003

The Weakest Link, Part 2
March 1, 2003

I have a small problem relating to the relationships that exist between a dimension table and a fact table.
February 3, 2003 I have a small problem relating to the relationships that exist between a dimension table and a fact table. There are two...

The Weakest Link
February 1, 2003

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

Is there any possibility of linking the measure of a particular fact to another fact in multiple fact star schema which needs the measure?
January 13, 2003 Is there any possibility of linking the measure of a particular fact to another fact in multiple fact star schema which...

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

Fingerprinting Data Warehouse Data
January 1, 2003

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?

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

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

We have a project that requires us to integrate up to 10 legacy customer-centric databases after a merger to build a customer marketing data mart.
November 5, 2002 We have a project that requires us to integrate up to 10 legacy customer-centric databases after a merger to build a...

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

The Internet Accessible BI Environment, Part 3
November 1, 2002

The Internet Accessible BI Environment, Part 2
October 1, 2002

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

I'm now doing a thesis about data mining in e-commerce.
September 4, 2002 I'm now doing a thesis about data mining in e-commerce. What techniques or patterns can I use other than association,...

The Internet Accessible BI Environment, Part 1
September 1, 2002

Report generation (BI) which searches and retrieves data from very large tables has resulted in slow database response-time and affecting the whole db performance.
August 26, 2002 Report generation (BI) which searches and retrieves data from very large tables has resulted in slow database response-...

What are the major comparisons or differences between Web mining and data mining?
June 25, 2002 What are the major comparisons or differences between Web mining and data mining?

We are using Ascential DataStage version 4.2 and I am having difficulty justifying the cost of the tool for Oracle source to Oracle warehouse loading of information.
June 25, 2002 We are using Ascential DataStage version 4.2 and I am having difficulty justifying the cost of the tool for Oracle source to...

Please explain the architecture of a data warehouse or direct me to books with figures so that I can visualize it.
June 25, 2002 Please explain the architecture of a data warehouse or direct me to books with figures so that I can visualize it.

What is the relationship between the data warehouse and data marts?
June 25, 2002 What is the relationship between the data warehouse and data marts?

This is my first query to you. I know bits and pieces about BI and the data warehouse.
June 25, 2002 This is my first query to you. I know bits and pieces about BI and the data warehouse. I have experience in OLTP systems....

What are the implications to a data warehouse implementation striving toward a zero latency enterprise (ZLE) solution?
June 5, 2002 What are the implications to a data warehouse implementation striving toward a zero latency enterprise (ZLE) solution? Is...

Is there a good end-to-end meta data tool?
June 5, 2002 Is there a good end-to-end meta data tool? I am concerned that companies pass off their approaches as meta data when they...

My company is planning to replace our old BI tool.
June 5, 2002 My company is planning to replace our old BI tool. One of our legacy systems uses an INGRES database. How much of a...

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

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

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

Can you identify some companies and products (other than Vality Corp. and their Integrity product) that can perform probabilistic matching on company names?
March 13, 2002 Can you identify some companies and products (other than Vality Corp. and their Integrity product) that can perform...

We are building an enterprise data warehouse.
February 7, 2002 We are building an enterprise data warehouse. Are there best practice guidelines on which (if not all) categories of data...

Which hardware and operating system platform(s) would you recommend for placing the actual data warehouse data on (one terabyte initially and then growing)?
February 7, 2002 Which hardware and operating system platform(s) would you recommend for placing the actual data warehouse data on (one...

Improved ETL Change Detection through Operational Meta Data
December 14, 2001 The ability to rapidly identify changes in source system data feeds can be enhanced by incorporating operational meta data...

Managing Current and Historical Views of Information in The Data Warehouse
August 3, 2001 Jennings explains how dimensional modeling techniques not only help design teams keep track of dimension table columns over...

Strategies for Custom Data Warehouse ETL Processing, Part 2
June 29, 2001 In his final installment, Jennings lays out a blueprint for customizing ETL processing and how the process improves data...

Strategies for Custom Data Warehouse ETL Processing
June 22, 2001 In the first installment of a two-part series, Jennings lays out a blueprint for customizing ETL processing.

Understanding the Role Web Logs Play in Data Warehousing
June 15, 2001 The author explains why project administrators are making the Web log a key part of their data warehousing initiatives.

The Generic Meta Data Repository
January 5, 2001 This classic article was published in the October, 2000 issue of DM Review. This article discusses how a generic model can...

The Generic Meta Data Repository
October 1, 2000 A generic model can help get the data warehouse project started by providing a template that can be tailored for specific...

Hewitt Relies on Data Warehouse to Service Clients' Benefit Plans
September 1, 2000

SyncSort UNIX Drives Formation of Data Warehouse at Hewitt Associates
July 1, 2000