Normalising Data with Data Models and Data Formats

Описание: Learn how to use Universal Platform's Data Modeling and Data Transform capability through this 30 minute video.

In this video we explore accessing a CSV file from a file share and then normalising the data into a set of SQL Server Database Tables.

We also look at constraints and using external keys to ensure the data uniqueness is maintained in the database no matter how many times it is repeated in the CSV file.