Supported Versions - Informatica Marketplace

Supported Versions - Informatica Marketplace

Name of Solution: Mapping : Columns to rows using Normalizer Business Requirement: PowerCenter example to pivot columns in a single row into multiple...

165KB Sizes 0 Downloads 11 Views

Recommend Documents

Supported Versions - Informatica Marketplace
100 Chandler Bing 26/06/1978 New York. 01/01/2009. Now the mapping will load the historical data in SCD Type-2 dimension

Informatica DTCC library error report - Informatica Marketplace
Informatica DTCC library error report. This document describes an enhanced HTML error report which can be created by lev

Informatica PowerExchange for IDMS - Informatica Marketplace
Informatica PowerExchange® for IDMS is part of Informatica's extensive PowerExchange family of universal data access an

Installation Guide - Informatica Marketplace
Set the group sticky bit on individual Fast Clone executables to enable them to run .... as a 32-bit Oracle source datab

Touchpoint Fact Sheet - Informatica Marketplace
Fact Sheet. iWay Touchpoint adapters provide pre-packaged multi-step processes that integrate standard business document

Evaxyx Siperian BPEL Framework - Informatica Marketplace
The code is more or less meaningless to anybody outside the development team. A typical enterprise application contains

Supported OS Versions for Windows Communication Tools Software
Supported OS Versions for Windows Communication Tools Software (as of February 23, 2017). Multiple ... For Win 7/8.1/10,

Red Cloak Endpoint Sensor Supported OS Versions - Secureworks
Windows Vista (32-bit and 64-bit) SP0 and later. • Windows 2008 ... Red Cloak is known not to run on the following ope

FAQ 1-4M9MLY Banner Supported Compiler Versions This note
Audit Trail: Support for Sun ONE Studio 8 or higher. Sep-04-2007. Information regarding NetCOBOL and 32-bit/64-bit. Oct-

Supported Operating Systems and Microsoft Excel versions for Platts
the Net and RealTick for Microsoft Excel®. ➢ Platts on the Net (POTN) is compatible with the following operating syst

Name of Solution: Mapping : Columns to rows using Normalizer

Business Requirement: PowerCenter example to pivot columns in a single row into multiple rows in the target using Normalizer Transformation.

Solution URL: https://community.informatica.com/solutions/1631

Supported Versions: Informatica PowerCenter 9.1 and above.

Description: Overview Developers sometimes need to transform one source row into multiple target rows. For example, attributes that are stored in columns in one table or file may need to be broken into multiple records - one record per column attribute - upon being loaded into a data warehouse. Source EMP_Name

EMP_Year

Transport

House_Rent

Food

Rachel Geller

2000

200

1500

500

Chandler Bing

2000

300

1200

300

Joey Frank

2000

300

1350

350

Target EMP_Name

EMP_Year

Expenses_Type

Expenditure

Rachel Geller

2000

Transport

200

Rachel Geller

2000

House_Rent

1500

Rachel Geller

2000

Food

500

Chandler Bing

2000

Transport

300

Chandler Bing

2000

House_Rent

1200

Chandler Bing

2000

Food

300

Joey Frank

2000

Transport

300

Joey Frank

2000

House_Rent

1350

Joey Frank

2000

Food

350

This mapping template demonstrates how to use a Normalizer transformation to split one source row into multiple target rows as shown above. Normalization is the process of organizing data. In database terms, this includes creating normalized tables and establishing relationships between those tables according to rules designed to both protect the data and make the database more flexible by eliminating redundancy and inconsistent dependencies. The Normalizer transformation normalizes records from VSAM and relational sources, allowing you to organize the data according to your own needs. A Normalizer transformation can appear anywhere in a data flow when you normalize a relational source. Use a Normalizer transformation instead of the Source Qualifier transformation when you normalize a VSAM source. The Normalizer transformation is primarily used with VSAM sources, which are often stored in a de-normalized format. The OCCURS statement in a COBOL file, for example, nests multiple records of information in a single row. Using the Normalizer transformation, you can break out repeated data within a record into separate records. For each new record it creates, the Normalizer transformation generates a unique identifier. You can use this key value to join the normalized records. Once you have created a Normalizer transformation in your mapping, you need to customize its properties. On the Normalizer transformation's "Normalizer" tab, you can set the port names, data types, key fields, precision and an Occurs value for each port passing through the Normalizer. Tips: • You can use a single Normalizer transformation to handle multiple levels of denormalization in the same record. For example, a single record might contain two different detail record sets. Rather than using two Normalizer transformations to handle the two different detail record sets, you handle both normalizations in the same transformation. • If you have de-normalized data for which the Normalizer transformation has created key values, connect the ports representing the repeated data and the output port for the generated keys to a different portion of the data flow in the mapping. Ultimately, you may want to write these values to different targets.

Download file contents: 1. Script 2. Mapping

Steps to implement the solution: 1. Execute the given script to create source table and Target table. 2. Import workflow using the Repository Manager. Select the appropriate folder from the repository and resolve the conflicts by choosing suitable option.

3. In the PowerCenter Designer, observe the logic of Normalizer Transformation as shown below,

4. Open the workflow in Workflow Manager. Assign the integration service in Workflow > Edit -> Integration Service 5. Edit session and assign valid connection object for the source and target. 6. Execute the workflow and observe the target files.

Other Useful links: Mapping Bundles Workflow Bundles Informatica Tools Bundles Informatica for Social Media Bundles Debugging Tools Bundles Visio Templates Bundles B2B Templates and Projects Bundles Data Quality Packs and Plans Bundles Script Bundles