• Personally I would just include a field in the dimension that stores the source where the record came from.

    Is it possible though the dimension info for one record can come from multiple sources?

    How would you use that information? Are you going to filter on it in reports? Or is it just for auditing?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP