Category: ETL

SQL Satuarday 316: Christchurch: ETL Architecture for Solving Data Warehouse Challenges

Posted on by Reza Rad

I am honored that I will speak in SQL Saturday 316 Christchurch on 14th of June 2014. Presentation topic is : ETL Architecture for Solving Data Warehouse Challenges presentation Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher performance, faster and more insightful data analysis Read more about SQL Satuarday 316: Christchurch: ETL Architecture for Solving Data Warehouse Challenges[…]

ComCamp 2014; Presentation Files: Solution Architecture for Inferred Dimension Members with SSIS and MDS

Posted on by Reza Rad

Thanks to all attendees of my session in ComCamp 2014 in Auckland about Solution Architecture for Inferred Dimension Members with SSIS and MDS. Here is session Title, Description, and presentation file; Title: Solution Architecture for Inferred Dimension Members with SSIS and MDS Description: Data Warehouses are heavily in use nowadays in most of businesses around Read more about ComCamp 2014; Presentation Files: Solution Architecture for Inferred Dimension Members with SSIS and MDS[…]

Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges

Posted on by Reza Rad

Thanks to all attendees of my session in TechDays 2014 Hong Kong about ETL Architecture for Solving Data Warehouse Challenges. Here is session Title, Description, and presentation file; Title: ETL Architecture for Solving Data Warehouse Challenges Description: Data Warehouses are heavily in use nowadays in most of businesses around the world. Data Warehousing brings higher Read more about Presentation Materials: TechDays Hong Kong 2014, ETL Architecture for Solving Data Warehouse Challenges[…]

Script to Generate and Populate Date Dimension Version 2: Adding Multiple Financial Years

Posted on by Reza Rad

Almost a year ago I published first version of T-SQL script to generate and populate a general purpose date dimension here. Today I want to publish the second version of that date dimension which has some corrections (fiscal calendar calculation fixed), and additional attributes (such as current year, current month, and current day) Multiple countries Read more about Script to Generate and Populate Date Dimension Version 2: Adding Multiple Financial Years[…]

Insert, Update, and Delete Destination table with SSIS

Posted on by Reza Rad

Previously I’ve wrote about design and implementation an UPSERT with SSIS. UPSERT is about Update existing records, and Insert new records. Today I want to extend this to cover DELETED records as well. So method used in this post can be used to find INSERTED / UPDATED / DELETED records from the source table and Read more about Insert, Update, and Delete Destination table with SSIS[…]

Speaking about Inferred Dimension Members with SSIS and MDS: Charlotte SQL Saturday

Posted on by Reza Rad

Hi folks, I proud to announce that I will speak in the SQL Saturday #237 Charlotte BI Edition Which will run in 19th of October 2013 in Charlotte, North Carolina  In this session I will speak on one of my favorite topics which is Design and implementation architecture for Inferred Dimension Members with SSIS and Read more about Speaking about Inferred Dimension Members with SSIS and MDS: Charlotte SQL Saturday[…]

Script for Creating and Generating members for Date Dimensions: General Purpose

Posted on by Reza Rad

Date Dimension can be found in every Data Warehouse, because Date dimension is one of the most important factors of each operational system that users like to view reports based on date dimension. So the importance and requirement to a date dimension persuade me to write a t-sql script to generate records for date dimension. Read more about Script for Creating and Generating members for Date Dimensions: General Purpose[…]

My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework

Posted on by Reza Rad

Hi folks, I will speak at 10th of August at Pass Data Warehousing and Business Intelligence Virtual Chapter. Session Title: SSIS Catalog; Big Step for ETL Framework Time: Fri August 10th 2:00 PM at NZDT , 12:00 PM at Brisbane = 9th August 10:00 PM EST Fri  August 10th 12pm – 1pm Brisbane, AU Timezone (GMT+10) (= Read more about My Session at Pass DW and BI Chapter – SSIS Catalog; Big step for ETL Framework[…]

SSIS Upsert With Lookup Transform

Posted on by Reza Rad

This is a very common question everywhere; how can I check if data is exists in destination table then update it, otherwise insert new records. This Scenario named Upsert in common ( Update / Insert ), there are lots of ways to do it, but in this post I’ll describe how to do it with Read more about SSIS Upsert With Lookup Transform[…]

Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS 2005

Posted on by Reza Rad

In previous post I presented a way for UPSERT in MySQL with SSIS 2008, in this post I present another solution which is compatible with SSIS 2005 for UPSERT in MySQL Table.As previous post shows, the main problem is: There are lots of links which described how to UPSERT( Update / Insert ) between two Read more about Update / Insert ( UPSERT ) MySQL Table From SQL Server Table – SSIS 2005[…]