Welcome back to the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series #XML, Auto & Path – Episode 2
Category Archives: Uncategorized
Banking OLTP Databases, Datawarehouses & Dimensions
In last week’s article “What an ODS is and how should you use it” I’ve explained the concept of an Operational Data Store and how it fits in the overall data warehouse picture.
Today I’m going get into the specific characteristics of OLTP Databases versus Data Warehouses and how the dimensional model fits into the overall picture in the interesting world of investment banking data warehouse and business intelligence reporting. Continue reading Banking OLTP Databases, Datawarehouses & Dimensions
#Thresqlips series Metadata, XML & Text files – Episode 1
Welcome to the first article of the weekly #thresqlips series comprising of three sql tips, definitions or “must-know”‘s that should be part of your database development vocabulary: Continue reading #Thresqlips series Metadata, XML & Text files – Episode 1
What an ODS is and how should you use it
When working on the design and implementation of a data-warehouse / business intelligence solution some of the most common questions that I receive are in relation to the ODS or Operational Data Store. In today’s post I’ll explain it’s purpose and the proper way to interact with it.
The definition of the Operational Data Store Continue reading What an ODS is and how should you use it
First assumption that could CRASH your Credit Risk Data Warehouse project
Over the past two weeks I’ve covered a summary for the implementation of a Credit Risk Reporting project which is available in two parts, How to Implement a Credit Risk Data Warehouse – Part 1 and How to Implement a Credit Risk Data Warehouse – Part 2 holding the overview of the implications and a structured best practices approach to be considered when enrolling on the delivery of such a project.
Today I will focus on a common preconception that could have a severe impact to the schedule, resources, cost, development and ultimately the delivery of your Credit Risk Data Warehouse & Reporting project. Continue reading First assumption that could CRASH your Credit Risk Data Warehouse project