Posts Tagged ‘DW’

Mule Flat File and Cobol Copybook Processing

A few months back, I worked on a project that involves flat file handling. I thought it was such an odd thing that people still use flat file in the 21st century. Ironically, I’m now on my 3rd project which involves flat file processing. It is not just flat file; I am actually dealing with […]

Story Points Estimation on a Data Warehouse Project

It has been decades since people started to develop data warehousing (DW) systems. In fact, most of the delivery strategy and approach on DW is to follow the traditional waterfall cycle – discovery, requirement, design, development, test, training, and transition, etc. With this pattern, only the previous step is completed; the team will start on […]

Why Does Data Warehousing Take So Long? Part 2

In my last post, I wrote about BI’s reputation for being a long drawn-out process. And of course, where the market sees a vacuum…  A plethora of products and processes exist to aid with “shortcutting” BI/DW development. So this time, I want to look some common factors at play when you use the various types […]

Teradata Temporal Feature in Data Warehouse Design

If you have read books or articles written by Ralph Kimball, you should know about basic components and process to complete a dimensional modeling for enterprise data warehouse (EDW). When an architect is designing on DW, he would have to think about the slowly change dimension (SCD) approach that will best suit the business need […]