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

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

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 […]

4.5 (2)

2020-11-12

3,428 reads

Blogs

Regression Testing SQL Saturday Naming

By

I started a poll today on the naming for future SQL Saturdays. You can...

Daily Coping 9 Apr 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Error creating Azure SQL Database

By

A quick post today, quite simply, the error message is: “code”: “ConflictingDatabaseOperation”,  “message”: “Operation on server x and database y is in progress.  Please wait a few minutes before trying again.” What...

Read the latest Blogs

Forums

socialcontentonline

By markisun35

absorbed in every flow of mine, the overseas students had been another time amazed...

Splitting a group up into multiple groups using a score....

By Rob Reid-246754

Splitting a group up into multiple groups using a score for how many times...

Whether to leave a clustered index on a staging table

By DamianC

Hi Using dataflows to load data from one SQL table to another (seperate databases;...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers