Tags » Data Warehouse

SQL Server data warehouse performance settings

This is the checklist you need to ensure your SQL Server environment is optimally setup for Data Warehouse loads. I have compiled it based on experience and the FastTrack data warehouse reference architecture. 166 more words

SQL Server 2014

Is ‘T‘ in ‘ETL’ under fire?

Is the element of Transformation in Extract Transform and Load under a jolt ?
What started as an alternative platform to keep replicated data to do some basic reporting later emerged as an inevitable element of IT landscape to make strategic decisions and operational optimization in the name of data warehouse. 293 more words

How to handle schema changes for tables with CDC on

In this article, I am going to show you how to deal with schema change in SQL SERVER CDC.

As we all know, CDC was used a lot in Data Warehouse project. 3,975 more words

Change Data Capture

Data Mart and Data Warehouse

As I mentioned in the previous post, Data warehouses are for data analysis, which is becoming a hot topic these days. So, in this post, let me explain about Data Marts which are part of data warehouse. 371 more words

Database

adMarketplace solves search intent challenge with HP Vertica big data warehouse

The next BriefingsDirect bid data trailblazer interview examines how New York-based adMarketplace, a search syndication advertising network, has met its daunting data-warehouse requirements.

Learn here how adMarketplace captures and analyzes massive data to allow for efficient real-time bidding for traffic sources for online advertising. 1,620 more words

Dana Gardner

New Year, New Name, Same Mission

Happy New Year!

Looks like it will be another busy one. So, let’s get going!

Yes, I just changed the name of my blog from “Oracle Data Warrior” to “The Data Warrior.” 287 more words

Oracle