From the course: Microsoft Azure Data Engineer Associate (DP-203) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Normalize and denormalize values

Normalize and denormalize values - Azure Tutorial

From the course: Microsoft Azure Data Engineer Associate (DP-203) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Normalize and denormalize values

“

- [Instructor] Well, once again, we can accomplish both of these goals using ADF with transformation activities. Normalization refers to data standardization and it means something slightly different depending upon whether we're in a relational SQL store, where you have your various normal forms and so forth, or a NoSQL store and Cosmos in particular, to use Cosmos DB as an example. One common question that you have in developing your Cosmos data model is how much data, entity data, you want to keep in a single JSON document, given that there's no relation between those documents? You can create links as such. Again, that's getting into DP-420 category. But just understand that we're not concerned with building a data model as an Azure data engineer. We're tasked with understanding what our data scientists want to do and then making it happen in ADF data flows and pipelines. So a Pivot transformation allows you to…

Contents