Handling Early Arriving Facts in SQL Server Integration Services (SSIS) Packages

(Ray Barley) We typically use the Lookup Data Flow Transform to retrieve the surrogate key for a dimension row based on the natural key in a fact table. While this works well, we occasionally have a situation where a fact table row has a natural key that isn’t in our dimension table and we’re looki

Read More - Register for Free Membership