Share via

Implement transformation in Azure Data Factory using Copy data component in Move and Transform section

jigsm 236 Reputation points
2020-10-06T23:09:08.093+00:00

I have implemented a pipeline using Copy data component from Move and Transform section.

The source is Azure Blob Storage and the Sink is Azure SQL Database.

The delimited file (csv) in Azure Blob Storage consists of a column by the name 'Gender' which consists of 2 values namely Male and Female.

But in the SQL DB, I need to store it in M and F format.

Is the a way to achieve this requirement using Copy data component?

Regards

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,981 questions
0 comments
Accepted answer
  1. MarkKromer-MSFT 5,201 Reputation points Microsoft Employee
    2020-10-06T23:55:04.35+00:00

    Use data flows for this. It's very easy. Add a blob store source, a Derived Column, and a Sink.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest