How to Automate Import of Data to Dimension

Link to the video

Under this link, you will find a video that shows how to automate import of data to a dimension.
Read more about defining dimensions here.

Step by step

1. Create a table containing the columns you want to import into the dimension. The columns in the staging table must match the dimension table columns by name and data type:

1. Create a Dataflow Item and add the Import dimension members task from the Dimension Tasks in the toolbox:

3. Specify the name of the staging table and the name of the dimension:

4. Create a Dataflow and run the Dataflow Item: