Tags » Data Warehouse

Slowly Changing Dimensions (SCD) Types

Slowly Changing Dimension work in different types of methods.

  1. SCD Type 0 (Never change record data)
  2. SCD Type 1 (Over write the previous record data)
  3. 113 more words
Data Warehouse

Slowly Changing Dimensions (SCD)

Slowly changing dimension is a concept to update and change the dimension table slowly rather than changing on fix interval or time based.

Why Slowly changing dimension ? 98 more words

Data Warehouse

Star Schema Vs Snowflake Schema

Star Schema:

  1. Start Schema fact table connected with multiple dimension tables like a Star Shape .        
  2. Star Schema is highly denormalized.
  3. Dimension table is not normalized due to this it take lot memory in system.
  4. 83 more words
Data Warehouse

Cardinals undrafted free agents: WR Amir Carlisle

With the NFL now America’s most widely followed sport, some little details that used to be overlooked are now widely followed.

Take undrafted free agents for example. 256 more words

Arizona Cardinals

SSIS How to Load CCI Table Efficiently


Lately I came across a topic to load data directly into Clustered Columnstore Index (CCI) via SSIS package. It was not working really well for the first time, so I needed to search around and test different SSIS parameters. 211 more words


News Bites: Pokémon Go Catches Restaurant Fever, Starbucks to Increase Wages & More

Nibble on this: 6 things happening in the world of food you should know.

1. Restaurants are cashing in on Pokémon Go fever.
When the… 691 more words


News Bites: Starbucks' Newest Summer Drinks, Free Slurpees at 7-Eleven, All-Black Hot Dogs & More

Nibble on this: 5 things happening in the world of food you should know.

Starbucks rolls out two more summer drinks.
It’s kind of official: Starbucks is on a quest to own our summer drink cravings. 458 more words