Skip to main content

Compare Multi-Model Versions

In this example, we will compare two multi-model data source models. In this case, the model content will have a directory structure and the comparison will be performed at two levels (the directory structure and at individual leaves that are internal models).

We will use the data lake as the multi-model. However, there are no additional versions of the data lake in the models folder, so we will edit one of the files.

Create a new model. Complete the dialog as follows:

In the Import Setup tab specify in the File parameter the location:

Information note

C:\DataCataloging

Click Save and then IMPORT .

When the import has completed, we will now make some changes for the comparison.

Information note

C:\DataCataloging\AdventureWorks Data Lake\HumanRessources

And rename Department.csv to be Dept.csv .

Edit Shift.csv and do the following:

  • Change the data values for the first column ( ShiftID ) to “S1”, “S2” and “S3”
  • Rename Name to ShiftName
  • Add a column Hours at the end of all the lines in the file.

The result should be like this:

Now, again click IMPORT on the model to import a new version.

Be sure to check the Full source import instead of incremental checkbox in order to avoid incremental harvesting.

Go to the Versions tab.

Information note

There are now two different versions of this model in the repository. The latest one is in the current configuration.

To compare the two versions you must step outside the configuration, so as to see all the versions of the model.

Go to MANAGE > Repository , expand the Comparison Data Lake model, right-click the latest version, and select Compare with previous version .

Click the row for the Shift.csv column with the difference icon .

Information note

The differences are in the model representing the Shift.csv file.

Click COMPARE MODELS .

Click the row for ShiftID .

Information note

The data type changed, as we did in the file earlier.

Information note

We see also Name was added and ShiftName removed. The comparison direction is critical to the presentation and determines whether something is considered added or removed.

Click SWAP.

Information note

Now, we see the added and removed icons in a more appropriate order, where we added the Hours column as well as renaming Name to ShiftName .

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!