Compare Multi-Model Versions

In this example, we will compare two multi-model data source models. In this case, the model 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:

Click Save and then IMPORT.

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

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.

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 .

Click COMPARE MODELS.

Click the row for ShiftID.

Click SWAP.