Supported Versions - Informatica Marketplace

Supported Versions - Informatica Marketplace

Name of Solution: Mapping: SCD Type-2 When Rows Are Repeated Business Requirement: PowerCenter mapping example that demonstrates how to implement the...

199KB Sizes 0 Downloads 21 Views

Recommend Documents

Supported Versions - Informatica Marketplace
Chandler Bing. 2000. 300. 1200. 300. Joey Frank. 2000. 300. 1350. 350. EMP_Name. EMP_Year Expenses_Type Expenditure. Rac

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: SCD Type-2 When Rows Are Repeated

Business Requirement: PowerCenter mapping example that demonstrates how to implement the Slowly Changing Dimension (Type-2) when source data has multiple occurrences of the same dimension key.

Solution URL:

Supported Versions: Informatica PowerCenter 9.1 and above.

Description: Overview SCD Type 2 tracks historical data by creating multiple records for a given natural key in the dimensional tables with separate surrogate keys. The mapping example to apply SCD type-2 on source data. Suppose a company is maintaining a table with the employee location details. An example of the data is given below: EMPLOYEE TABLE E_ID 100 100 100

E_NAME Chandler Bing Chandler Bing Chandler Bing

E_DOB 26/06/1978 26/06/1978 26/06/1978

E_LOCATION Texas Las Vegas New York

START_DATE 01/01/2000 01/01/2006 01/01/2009

Now the mapping will load the historical data in SCD Type-2 dimension table. So the data will look like as shown below after it has been passed through mapping. SEQ E_ID E_NAME E_DOB E_LOC S_DATE E_DATE 101 100 Chandler Bing 26/06/1978 Texas 01/01/2000 12/31/2005 102 100 Chandler Bing 26/06/1978 Las Vegas 01/01/2006 12/31/2008 103 100 Chandler Bing 26/06/1978 New York 01/01/2009 12/31/9999 Note: The End_Date with 12/31/9999 in row indicates the current tuple version.

Download file contents:  

PowerCenter mapping XML Oracle scripts to create a source and target.


Steps to implement the solution: 1. Compile the script in the database to create source and target tables. 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, study the mapping and how transformations are designed.

4. Observe the logic of Router transformation as shown below.

5. Open the workflow in Workflow Manager. Assign the integration service in Workflow > Edit -> Integration Service. 6. Edit session and assign valid connection object for the source and target. Make sure that the lookup transformation also gets the valid connection. 7. Execute the workflow and observe the output in the target table. The SCD type 2 is implemented when rows are repeated.

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