Data Vault type Hub
1. Creating Data Vault type Hub Designer
To create a new SCD2 go to SOURCE, then select the data set in which the designer will be located. Then click Views. A list with all Views created in this Data source will be displayed on the right. In this example, the list is currently empty. So click "CREATE VIEW".
Fill out the required fields on the form by selecting "dimension designer" as the type and click the NEXT button
Then select Data Vault Hub in "Set dimension type". A "drag and drop" field will be displayed, marked "drop table here". Select the source table and drag it to the "drop table here" field.
After selecting the table, the standard Data Vault Hub designer will be displayed. Designers can be configured as needed. Among other things, you can assign columns to the "Business key" table, change names and add and drop columns or change their types. Then click “NEXT” or "CREATE".
If you selected “NEXT” you will see the generated SQL query and the columns that will be created. If everything is OK, click "CREATE". Data V has been created. You will return to the "Views" tab. Now the list on the right contains the new Data Vault.
- 2. Example.
Click on the newly created view. Select “Preview data” i click “SHOW DATA”.
Sample Data Vault table data looks like this:
After adding a source table row it looks like this:
- 3. Data Vault Hub edition
To enter the screen for editing an existing Data Vault, go to SOURCES, select the dataset it is in, select Views and select the previously made designer from the list.
In "Summary" click Edit. A view similar to taking a new DV will open.
- 4. Data Vault removal.
To remove a designer, click DELETE in Summary, confirm this in the next view.