Type2 Dimension/Version Data Mapping: In this mapping the updated dimension in the source will gets inserted in target along with a new version number. Newly added
dimension in source will inserted into target with a primary key.
Type2 Dimension/Flag current Mapping: This mapping is also used for slowly changing dimensions.In addition it creates a flag value for changed or new dimension.
Flag indiactes the dimension is new or newlyupdated.Recent dimensions will gets saved with cuurent flag value 1. And updated dimensions are saved with the value 0.
Type2 Dimension/Effective Date Range Mapping: This is also one flavour of Type2 mapping used for slowly changing dimensions.This maping also inserts both new and
changed dimensions in to the target. And changes are tracked by the effective date range for each version of each dimension.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment