Bundle: PowerCenter Transformations - 2
Posted by: Informatica Marketplace
PowerCenter Mapping templates that demonstrate how to use PowerCenter features to solve complex transformation scenarios.
Overview
The bundle contains the following set of listings. Visit individual listings for details.1. Mapping : Dynamic Query in SQL TransformationA PowerCenter Mapping example to generate queries dynamically to update only the NULL columns of the target.2. Mapping : SQL Transformation with Non-Equi JoinDemonstrates the technique to join heterogeneous relational sources with a non-equi join condition using a SQL transformation.3. Mapping : Filter Duplicates with Dynamic LookupA Informatica PowerCenter mapping to demonstrate how to handle duplicates in source rows by using the Dynamic Lookup.4. Mapping : Multi Match Lookup for Non-Equi JoinPowerCenter mapping that demonstrates the technique to join heterogeneous relational sources with a non-equi join condition using a Lookup Transformation.5. Mapping : Multiple Match Lookup to get CountFind count of orders for a customer using a Lookup transformation with Multi Match enabled.6. Mapping : Optimize Updates using Dynamic LookupUse a Dynamic Lookup to avoid unnecessary database updates.7. Mapping : Generate Sequence using Dynamic LookupUse a Dynamic Lookup to generate the primary key during Data Warehouse dimension load.
Features
- Informatica PowerCenter 9.5.
