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	Insert - Users select this option to insert rows to the fact table. Update - Users select this option to update rows in the fact table.
Dimension Lookups	Add Lookup - Creates a new lookup ready for configuration. Remove Lookup - Removes the selected lookup.
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	Include - Selects the column(s) to be used for destination column mapping. Column - The name of the column. Column Alias - Users can create a column alias. Default Value - Users can assign a value to replace NULLs.
Configure Dimension Table Join Conditions To Source Data	And - Select the expand button to create join condition(s). All lookups require a condition to be configured.
Lookup Failure Action (Set to each lookup)	Set To Default - NULLs in the lookup are replaced with the default value defined in the Columns From Lookup. Fail - NULLs in the lookup causes the component to fail execution.

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.