diponkar.paul

Diponkar Paul has 12 years of experiences in IT industry and specialized in Business Intelligence domain, currently working as a Senior Data Engineer at Fiera Capital, Canada. Through his career, he designs and developed medium and large data warehouses and delivered business critical analytical solution. He was leading Toronto PASS Group; which is part of the world largest data professional community named PASS and Lead of Toronto Data Professionals Community.He got diverse background, has been working and studied in different Geo location includes Canada, Denmark, UK, Sweden and Bangladesh. He writes technical blog and speaking, he loves to share his learning within the community.

Interests: Data, Travel, Swimming, Cycling, cross-country skate
Blog: http://allaboutdata.ca/
Jobs: Senior Data Engineer
Skills: Big data, Business Intelligence, Database, ETL, ELT, Data Warehouse

Twitter: @@paulswengrr
Website: http://allaboutdata.ca/
LinkedIn: https://www.linkedin.com/in/diponkarpaul/

How to simulate Case statement in Azure Data Factory (ADF) compared with SSIS?

by diponkar.paul

SQLServerCentral

This post will describe how you use a CASE statement in Azure Data Factory (ADF). If you are coming from SSIS background, you know a piece of SQL statement will do the task. However let's see how do it in SSIS and the very same thing can be achieved in ADF. Problem statement For my […]