ADF

SQLServerCentral Article

How to Flatten JSON in Azure Data Factory?

  • Article

When you work with ETL and the source file is JSON, many documents may get nested attributes in the JSON file. Your requirements will often dictate that you flatten those nested attributes. There are many ways you can flatten the JSON hierarchy, however; I am going to share my experiences with Azure Data Factory (ADF) […]

4.5 (2)

You rated this post out of 5. Change rating

2021-09-17

7,806 reads

SQLServerCentral Article

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

  • Article

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)

You rated this post out of 5. Change rating

2020-11-12

10,860 reads

Blogs

How to Connect Your WordPress Site to the Fediverse

By

Make it easier for your audience to engage with you by connecting your site...

What I learned volunteering at a children's summer camp

By

 "Stories are where memories go when they are forgotten" - Doctor Who.(2024-Sep-13) As September quickly...

A New Word: Fensiveness

By

fensiveness – n. a knee-jerk territorial reaction  when a friend displays a casual interest...

Read the latest Blogs

Forums

test new topic

By philip.scott

posting a new topic

New article

By Steve Jones - SSC Editor

Comments posted to this topic are about the item New article

Monitoring Azure Blob Storage

By arindamxs

Comments posted to this topic are about the item Monitoring Azure Blob Storage

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers