Tags » Data Warehouse

Date Ranges in Data Warehouses using Oracle 12c

When you load data with an “effective date” into a Data Warehouse, what happens when the new data is the same as yesterday’s? Do you add a new record with the new “effective date” or do you update a date range in the existing record? 935 more words

Compare And Sync

Avoiding the Update

A couple of days ago I blogged on long running facts and mentioned my loathing of updating data. Sometimes though we can’t avoid having to change what is already loaded, be it closing of a fact in a temporal data warehouse or updating a dimension table. 619 more words

Data Warehouse

Data warehouse - Test Data Mangement

Test Data Management

Hi All,

Hope all are doing great….it’s very long time since I posted through my blog… my sincere apologies  :-(

Happy Reading……:-) 864 more words

Data Warehouse Testing - Learners Guide

Long Running Facts

Life used to be simple. Our data warehouses reported “things” at points in time. We knew how many widgets we had in stock on 31 July 2012, we knew our total sales on 6 May 2014. 694 more words

Data Warehouse

Power Query – Your next ETL solution – With Power Update

When Power Query was launched as part of Power BI in February of ’14, the BI community applauded the flexibility and power that Power Query represented. 223 more words


Designer's conflict:

1 problem.. so many solutions:

Every engineering or other design challenge can be addressed in multiple ways. There are generally, at least 2 good solutions, to pick from. 477 more words


Neustar at re:Invent 2014

On Thursday, Nov. 13th I was given the opportunity to speak at AWS re:Invent 2014 about the ad analytics products and platforms we’ve built on Redshift.  123 more words

Big Data