FACT TABLE DESTINATION
There are two ways to load a fact table in SSIS. The slow, frustrating way with multiple time-consuming,
cache filling, memory pressuring dimension lookups, as well as splitting data between insert and update just to test the package.
Or you can load them the super simple way by using Task Factory's Fact Table Destination!
With just a single user interface, you can choose between insert and update actions for the fact table,
configure table join conditions to dimension tables from their source data, create column aliases for multiple lookups on
the same dimension and define a default value to prevent NULLS from being added.
Advanced features like ranged lookups are also supported. Save hours off your fact table development and load with this batch process!