KingswaySoft
Premium Slowly Changing Dimension
Premium Slowly Changing Dimension SSIS component, is a greatly enhanced SCD component that simplifies the change tracking of data warehouse dimensional data with much greater flexibility. With the Premium Slowly Changing Dimension component, our top priority is offering the greatest usability for developers so less time will be spent working with the tool.
With Premium Slowly Changing Dimension component developers can rest assure their data integrity is being upheld within their data warehouse. This intuitive component offers greater metadata handling which means the component does not need to be re-configured when changes are made in the data inputs.
The Premium Slowly Changing Dimension component, part of the SSIS Productivity Pack, segregates data into 3 simple outputs, New Rows, Changed Rows and Unchanged Rows depending on what changes have occurred to the source dimensional data. The component also supports writing directly to a database so no additional outputs are needed.
Greater Performance and Developer Usability
Premium Features Overview
Below is a break-down of how the features of the native SSIS Slowly Changing Dimension
wizard compares to the Premium Slowly Changing Dimension component.
| Feature | Out-of-Box Slowly Changing Dimension | Premium Slowly Changing Dimension | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
User Interface & Experience |
Can be time consuming when changes need to be made. |
Offers a similar UI to other SSIS components which enable developers to quickly move through the component configuration and between pages. Developers can easily make changes later without having to reconfigure the component each time it is opened. |
||||||||||||
|
Fixed, Changing, & Historical Attributes (Type 0, Type 1, Type 2) |
Yes |
Yes |
||||||||||||
| Current Dimension Input |
|
|
||||||||||||
| Outputs |
|
The component segregates data before output so developers have 3 simple outputs which can be immediately sent to the appropriate destination without any further transformations needed for easier development and processing. |
||||||||||||
| Writing |
|
Component supports writing directly to an ADO.NET connection without the need to configure additional destinations when writing to a database. |
||||||||||||
| Supports Compound Business Key |
|
|
||||||||||||
| Column Configuration & Change Type Selection |
|
Set-up in one simple grid, developers can configure mappings, select their business keys(s) and select the necessary change type all within 1 page offering an immediate overview of the configuration. With all fields already presented, developers spend much less time configuring the component. |
||||||||||||
| Surrogate Key |
|
Allows developers to specify the Surrogate Key which can be useful when performing inserts and updates later in the workflow. Also includes advanced settings for specifying how a Surrogate Key should be generated for new records. |
||||||||||||
|
||||||||||||||
| Inferred Members |
|
With advanced data handling within the component the Inferred Members setting becomes unnecessary. |
||||||||||||
| Supported Destinations |
|
If developers do not want to write directly to an ADO.NET connection from within the component, the component also supports use of any component in the downstream outputs. |
||||||||||||
| OLE DB Command Transform |
|
Data is processed and segregated before output simplifying the pipelines and eliminating the need for the OLE DB Command Transform component. |
||||||||||||
| Error Handling |
|
The component offers the ability for Fail on Error, Redirect Rows to Error Output or to Ignore Error when any errors occur. With Redirect Rows to Error Output the component will continue running and not disrupt the entire data flow. |
||||||||||||
