Hi,
I've a query on Slow Changing Dimensions (SCD) Stage.
Do we need to sort the data (on the input links) on the Business Keys being used in the stage?
Is it mandatory for proper functioning of SCD stage, like we do for Join and Merge stages?
Thanks.
Query on SCD Stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Yes, the partitioning should match on both links. However, if the other link is set to "auto" then DataStage will determine that it needs to be set to match the other input stream and set it to "Hash" on the right keys without tell you. I believe if you look at the osh you can verify that.
However, I always recommend setting stages explicitly so it is more evident where the partitioning is occurring.
However, I always recommend setting stages explicitly so it is more evident where the partitioning is occurring.
Yes and No. Yes, the partitioning should match on both links. However, if the other link is set to "auto" then DataStage will determine that it needs to be set to match the other input stream and set it to "Hash" on the right keys without tell you. I believe if you look at the osh you can verify that.
However, I always recommend setting stages explicitly so it is more evident where the partitioning is occurring.
However, I always recommend setting stages explicitly so it is more evident where the partitioning is occurring.