- 1. Creating SCD2 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 SCD2 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 SCD2 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". SCD2 has been created. You will return to the "Views" tab. Now the list on the right contains the new SCD2.
- 2. Example
Click on the newly created view. Select “Preview data” i click “SHOW DATA”.
Sample SCD2 table data looks like this:
After adding a source table row, SCD2 looks like this:
- 3. SCD2 edition.
To enter the screen for editing an existing SCD2, go to SOURCES, select the dataset it is in, select Views and select the previously made SCD2 from the list.
In "Summary" click Edit. A view similar to taking a new SCD2 will open.
- 4. SCD2 removal.
To remove a designer, click DELETE in Summary, confirm this in the next view.