Data, Information and Analytics

November 14, 2020January 22, 2025Analytics Industry, Architecture, Build, Business Data Vault, Change, CICD, Data, Data Lake, Data Lakehouse, Data Quality, ELT, ETL, Framework, Informatica PowerCenter, IT, MATILLION, Maturity, SQL

So you need a framework?

In my career I have used and built many ‘frameworks’. Typically they are focused on Data Warehouses delivery involving the Extraction, Transformation […]

June 14, 2020February 16, 2025Build, Change, Data, Data Quality, ETL, IT

‘What do you mean they physically delete the data!!!’

Introduction I have heard myself say these words many times, and yet it always comes as a surprise, surely people know that […]

January 18, 2018January 24, 2021Build, ETL, Informatica PowerCenter

Querying the Informatica PowerCenter Repository

The following are a collection of SQL Server Scripts for querying the Informatica PowerCenter Repository. Please note that this is not supported […]