Task Factory

Fact Table Destination

The Fact Table Destination loads data warehouse fact tables in a fraction of the time and with much less development work.


Fact Table Destination

Feature Image

Fact Table Destination can greatly reduce development time for SSIS packages with multiple dimension lookups. With the Fact Table Destination, developers can now perform these lookups and insert data into a fact table within a single UI.

Additionally, users 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 load with this batch process.

Feature Highlights

  • Load a fact table using SSIS in a fraction of the time
  • Perform ranged lookups during the load to reload historical data
  • Reduction in development time
  • Performs surrogate key lookups in bulk

Testimonial What People Say About Task Factory

“We got Task Factory mostly because of Pragmatic Works reputation for the service they provide and the specific need of a secure SFTP task.”

Matt Cushing
Matt Cushing
Loews Corporation

“At the University of Calgary, I can say with confidence that halfway into the conversion effort, using Task Factory has been one of our smartest and most cost-effective software acquisitions in recent memory.”

Gabriel Gray
Gabriel Gray
University of Calgary

Our Clients 96% of fortune 100 companies trust pragmatic works:

Our StatsSome of our cool facts

  • 200x
    More frequent deployments
  • 24x
    Faster recovery from failures
  • 3x
    Lower change failure rate
  • 2555x
    Shorter lead times

Articles & Tutorials

Task Factory Transforms SSIS to a True Data Warehouse Solution for the University of Calgary

In this case study, you'll learn how Pragmatic Works' Task Factory helped the University of Calgary transform SSIS into a true data warehouse solution. Read More

Webinars & Videos

Loading a Fact Table in SSIS
Build a Better Data Warehouse with Advanced Components from SSIS and Task Factory
Accelerate SSIS today
Task Factory Pro Edition
Help Documentation
Download Data Sheet

Please reach out to us to start your digital transformation journey.

Task Factory
Call Us At: (904) 413-1911

Contains 65+ tasks, connection managers, sources and Destinations for SSIS. You can compare editions here. Task Factory does not require a license while you're running packages in Visual Studio.