Task Factory Fact Table Destination
Fact Table Destination
Destination Icon | Destination Description |
---|---|
The Fact Table Destination gives developers the ability to perform all of the lookups required to insert or update a fact table. |
Options
Option | Description |
---|---|
Destination Connection Manager | Creates or selects a connection to the destination database (must be SQL Server 2008 or above). |
Fact Table Name | Selects the destination fact table. |
Destination Actions |
|
Dimension Lookups |
|
Dimension Table For Key Lookup | Selects the dimension table for each lookup. |
Alias | Users can assign an alias for the selected dimension table. Note: This should be used for performing multiple lookups on the same dimension. |
Columns From Lookup |
|
Configure Dimension Table Join Conditions To Source Data |
|
Lookup Failure Action (Set to each lookup) |
|
Destination Column Mappings
Option | Description |
---|---|
Key | Selects the key(s) needed when performing updates. |
Input Column | The user selected input column to be mapped to the destination. |
Destination Column | Name of the destination column. |
Scripts
Users can write custom TSQL queries to be performed before or after each buffer.