CODEWITHSUNDEEP
azuressisazure-data-factory
SeaQwell
SeaQwell

Reputation: 1

Azure Data Factory equivalent to SSIS 'data conversion transformation' task?

I'm wondering if anyone familiar with Azure data factory can help me figure this out. In SSIS I use the "data conversion transformation" task. It might be staring me right in the face, but I can't find the equivalent task in azure data factory. Anyone know? TY

I've looked through all of the ADF tasks available and none seem to cover data conversion.

Upvotes: 0

Views: 460

Answers (1)

Ziya Mert Karakas
Ziya Mert Karakas

Reputation: 891

That is either the Mapping dataflow activity or PowerQuery activity depending on what you want to do. If your goal is ETL/ELT then its dataflow either in ADF or Synapse pipelines (they are the same thing essentially). The activity you talked about in SSIS essentially changes the datatype of the column and copies to another column, for example int64 into float.

In ADF mapping dataflow, this transformation is called Cast under Schema modifiers, influenced by the spark logic:

https://learn.microsoft.com/en-us/azure/data-factory/data-flow-cast

Here is a nice video i found:

https://www.youtube.com/watch?v=OUX4ALdBbvA

Upvotes: 0

Related Questions