开发者

Dimension Changes Based on Source to Dimension Value Comparison

开发者 https://www.devze.com 2023-03-17 15:46 出处:网络
am using the Kimball SCD Component in SSIS.I would like to be able to direct rows to the type 1 or type 2 paths based on a comparison of the current dimension value to the source data, i.e., if a date

am using the Kimball SCD Component in SSIS. I would like to be able to direct rows to the type 1 or type 2 paths based on a comparison of the current dimension value to the source data, i.e., if a date in the source is less than the corresponding current date in the dimension, then type 2 else type 1.

Has anyone done any of this type of data comparisons? I've considere开发者_如何学Pythond using a trigger, but the performance hit would probable be huge.

It seems like a splitter would work, but I don't see where I can evaluate values of the two data streams.

Thanks,

0

精彩评论

暂无评论...
验证码 换一张
取 消