Bundle: PowerCenter Mappings for Data Warehouse

Bundle: PowerCenter Mappings for Data Warehouse

Posted by: Informatica Marketplace

Useful Mapping examples that can help you save time or optimize your work while working with Data Warehousing projects.

Overview

The bundle contains the following set of listings. Visit individual listings for details.1. Mapping : Load Data Warehouse DimensionThis template demonstrates a solution to load a Data warehouse dimension table using Informatica PowerCenter.2. Mapping : Sample Date DimensionInformatica PowerCenter sample mapping to load date dimension table.3. Mapping : Incremental Extraction of SourceInformatica PowerCenter mapping to automate the incremental extraction of source rows using Mapping Variable functionality.4. Mapping : Useful Date CalculationsA PowerCenter Mapping example which provides very useful date related  formulas which demonstrates the power of built-in date functions.5. Mappings to read rejected rows/dataPowerCenter Mappings to help you identify the data that is rejected by integration service while running a session.6. Mapping : Denormalization using Date DimensionIt is leveraging the data dimension when there is a need to generate multiple rows for a date range present in a source row.7. Mapping : Converting GMT to US time zones with DSTA reusable PowerCenter mapplet to convert time from GMT to US time zones, taking care of Day Light Savings.8. Mapping : Incremental AggregationIncrease performance of aggregate processing using in-built incremental aggregation functionality in Informatica PowerCenter.

Features

System Requirements:

  • Informatica PowerCenter 9.5.

Support