Home MSBI
Category: MSBI
Introducing Azure Data Factory Data Flows
Prasad KulkarniDec 04, 2019
They say that life comes full circle i.e. you start and end at the same point. However, in my humble opinion, that is not true. Life is like an unending spiral. You do...
Introduction to SSIS and making it metadata independent
Prasad KulkarniNov 21, 2019
Introducing SSIS In the Microsoft Sql Server Integration services (SSIS), we have a variety of tasks to perform ETL. However, with changing data landscape and newer...
Comparing SSIS Lookup and SQL Joins
Prasad KulkarniOct 09, 2019
Motivating SSIS lookups Denormalization is the most important step to create a Data warehouse. Fundamentally, we do so to populate surrogate key of a dimension in a fact...