文本案例白皮书mappingwizards

1、Confidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Mapping Wizards ObjectivesAfter this section, you should be able to describe: How to handle changes in dimension tablesGetting Started Wizard functionalitySlowly Changing Dimension Wizard functionalityConfidential and propri

2、etary. Copyright 2005 InfoPower. All rights reserved.Handling Changes in DimensionsIdentify the types of dimensionsStatic ChangingIdentify how much history is neededNoneAll changesMost recent changes onlyRefresh strategies for all dimensions can be designed in InformaticaConfidential and proprietary

3、. Copyright 2005 InfoPower. All rights reserved.Dimension TypesConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Refresh Strategies for DimensionsConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Mapping WizardsUse the Getting Started Wizard forAny

4、 static tablesAny slowly growing tablesUse the Slowly Changing Dimension Wizard forAny slowly changing tablesConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.The Getting Started Wizard - Mapping TypesSimple Pass ThroughSlowly Growing TargetConfidential and proprietary. Cop

5、yright 2005 InfoPower. All rights reserved.Simple Pass Through Mapping By default: Selects all rows Inserts all rows to target table Functionality is customizableConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Slowly Growing Target Mapping By default: Performs target tabl

6、e lookup Filters out existing rows Inserts new rows to target table Functionality is customizableConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Type 1 DimensionType 2 Dimension - Version DataType 2 Dimension - Flag CurrentType 2 Dimension - Effective Date RangeType 3 Dim

7、ensionSlowly Changing Dimension - Mapping TypesConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Type 1 Dimension MappingData flow forchanged rowsData flow fornew rowsConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Type 2 Dimension - Version Data

8、 MappingIncrements primary keyand version numberfor changed rowsGenerates primary keyand version numberfor new rowsConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Type 2 Dimension - Flag Current MappingSets current flag to 1 for new or changed rowsSets current flag to 0for old rowsConfidential and proprietary. Copyright 2005 InfoPower. All rights reserved.Type 2 Dimension - Effective Date Range MappingSets PM_BEGIN_DATESets PM_END_DATEConfidential and proprietary. Copyright 2005 InfoPower. All rights reserve