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
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
In How to implement a Credit Risk Data Warehouse – Part 1 I did an overview and an executive summary of the activities required for the delivery of Credit Risk Data Warehouse project. If you haven’t read this already I recommend you read How to implement a Credit Risk Data Warehouse – Part 1 first.
In addition to the above, the DW Architect, Project Manager & their teams will have to work and define the implementation approach, which will allow the Implementation team to complete the work on an accelerated timeline.
Usually a multistage “work breakdown structure” approach for the implementation phases of the project is preferred. Continue reading How to implement a Credit Risk Data Warehouse – Part 2
Some of the limitations with Indexed views are:
- The UNION operation is not allowed in an indexed view.
- We cannot create an Index on a nested view scenario which means we cannot create index on a view built from another view.
In the past years I’ve worked as a hands-on architect on the design and implementation of various data migration, data warehouse and business intelligence systems in various industries like Insurance, Retail, Food & Bev’s, Pharma & Investment Banking. Out of all nothing quite stands out like the complexity of building a Credit Risk Data Warehouse & Reporting system for the compliance with the Basel Regulatory requirements. Continue reading How to implement a Credit Risk Data Warehouse – Part 1