How to Implement Late Arriving Dimensions in SSIS 2022

libpekin 166 Reputation points
2024-06-16T21:20:42.16+00:00

Hello,

I'm looking for end-to-end documentation, if possible, with demo packages on implementing Late Arriving Dimensions use case leveraging the Inferred Flag approach in SSIS 2019/2022.

I've been researching this for a while, and although there are numerous blogs/articles on the subject, they all seem to fall short on how this is implemented in SSIS with tangible examples.

Any help is appreciated. Thanks!

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,592 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 37,671 Reputation points
    2024-06-17T02:32:42.95+00:00

    Hi @wiseguy,

    Kindly check if this blog is helpful.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.