Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(10 Ratings)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

Knowledge Link: Working with PowerCenter Transformations
Content

Click the transformation name to learn more about it: 

General

The following articles cover general PowerCenter transformation topics:

 

Article ID

Title

16229

Concatenation and active transformations in PowerCenter mappings

9149

"Concatenation disallowed. Active transformations" when attempting to connect a port in a PowerCenter mapping

105039

FAQ: Which databases and transformations are supported for the Pushdown optimization in PowerCenter 8.6?

18952

FAQ: Does a PowerCenter session allocate memory for each transformation cache independently?

102574

HOW TO: Enable shared Dynamic Cache for inserts in PowerCenter 8.6.1

10303

FAQ: What is the difference between the "Link Columns", "Copy Columns" and "Move Columns" options in PowerCenter Designer?

20634

What kind of changes made to reusable transformations will invalidate mappings that use them?

9590

HOW TO: Convert a reusable PowerCenter repository object to a non-reusable Object

 

Aggregator

The following is a list of articles that discuss the Aggregator transformation:

 

Article ID

Title

17598

HOW TO: Run a PowerCenter session with a sorted aggregator on a PowerCenter Server without a partitioning license

16297

MAPPING TEMPLATES: Aggregation using sorted input

10954

"SM_7072 Aggregate Error: Expecting keys to be descending." running a PowerCenter session with an Aggregator transformation

13973

FAQ: If you group the output data for an Aggregator transformation, is the output sorted by the grouped ports?

106106

FAQ: Can an Aggregator transformation be placed downstream of a "transaction control" transformation within a mapping?

105591

HOW TO: Find the Aggregator cache size and directory information in a repository

20369

FAQ: What are the limitations of the Aggregator sorted input option?

32053

HOW TO: Control the handling of NULL values in a PowerCenter Aggregator transformation

 

Custom

The following is a list of articles that discuss the Custom transformation:

Article ID

Title

17621

PowerCenter Custom Transformation Guide

102616

Changing the default row strategy with Custom Transformation

106157

Building a Custom Transformation on zLinux

15528

HOW TO: Write error messages with error code to session log using a Custom Transformation

14485

HOW TO: Retrieve the metadata extensions and Initialization properties of a Custom Transformation

107511

HOW TO: Prepare a repository with Custom transformations to upgrade to powercenter 8.6 (nondeterministic_resumable_pre860.sql)

17437

HOW TO: Use the PowerCenter session tracing levels with Custom transformations

17858

FAQ: What is the relationship of the codepage used by a Custom transformation and the PowerCenter Server code page?

Expression

The following is a list of articles that discuss the Expression transformation:

 

Article ID

Title

101913

FAQ: Can ports from two application Source Qualifiers be linked to the same Expression transformation?

32160

Tips for using the abort function in a expression transformation

23079

HOW TO: Determine when to use quotes strings inside an Expression transformation and Lookup SQL override

16318

MAPPING TEMPLATES: Aggregation using Expression transformation

13648

FAQ: Is there a PowerCenter function that is equivalent to the LIKE function?

104070

Records rejected at Expression transformation are not shown in the rejected record count in the Workflow Monitor

 

For more expression examples, refer to Knowledge Link: Working with PowerCenter Transformation Language.

External Procedure

The following is a list of articles that discuss the External Procedure transformation:

Article ID

Title

16317

MAPPING TEMPLATES: Load using External procedure

107025

FAQ: Should external procedures be recompiled when PowerCenter is upgraded from one version to another?

14094

HOW TO: Generate Custom Transformation or External Procedure code for a module or a library that contain multiple procedures

20022

FAQ: Does PowerCenter support the AIX XL C/C++ compiler?

Java

The following is a list of articles that discuss the Java transformation:

Article ID

Title

18681

PowerCenter Java transformation example

21635

HOW TO: Add third party JAR files in the Java transformation

22258

HOW TO: Use the SAPJCo.jar in a PowerCenter Java transformation

22817

HOW TO: Use a Java transformation to insert/update records to a database

22794

Debugging the Java Transformation with Eclipse

32298

HOW TO: Decode a base 64 encoded string and convert to ASCII using a PowerCenter mapping

32266

HOW TO: Pass mapping parameters or session parameters to Java codes in Java Transformation

102235

FAQ: What is the purpose of the Java.exe file in the client installation folder?

103049

FAQ: Are bitwise operators (such as left shift or right shift) available in PowerCenter?

102757

FAQ: What JAR file is used by PowerCenter for processing the Java Transformation and how do we deploy the user-defined JAR files that are used by Java Transformation?

18444

FAQ: What Java code is used with the PowerCenter 8.1 Java transformation?

22316

FAQ: Where is the location of the JAR files for external packages specified in a Java Transformation?

21512

FAQ: What is the difference between an active and a passive Java transformation?

32436

FAQ: What are the JAVA CODE sections in a Java transformation used for?

Joiner

The following is a list of articles that discuss the Joiner transformation:

Article ID

Title

16632

FAQ: Joiner Transformation FAQs

19304

HOW TO: Use a Joiner Transformation instead of Lookup Transformation

21065

HOW TO: Configure Joiner transformation for real-time sessions

17166

HOW TO: Extract records which do not satisfy a join condition using a Joiner transformation in a PowerCenter Mapping

105583

HOW TO: Find the Joiner cache size and directory information in a repository

17701

FAQ: Does a PowerCenter session retain the data sort order when joining data with a Joiner transformation?

108465

FAQ: What Join algorithms are used by the PowerCenter Joiner transformation?

16438

"The mapping contains blocking transformations which may cause the mapping to hang while executing." when validating a PowerCenter mapping with multiple Joiner transformations

13947

"Concatenation disallowed on transformation" connecting ports from different XML Views or multiple groups to a Joiner transformation in a PowerCenter mapping

14595

HOW TO: Determine the number of Master rows for a Joiner transformation

11086

FAQ: Can a PowerCenter mapping be configured to perform a non-equi join on heterogeneous sources?

11344

HOW TO: Create a cartesian join with a PowerCenter mapping

Lookup

The following is a list of articles that discuss the Lookup transformation:

Article ID

Title

101781

FAQ: Can a non-input port be used in the Lookup Source Filter property?

18388

FAQ: How does PowerCenter DTM maintain connections for Lookup Transformation and Stored procedure?

20577

FAQ: How are lock files used with Lookup cache files?

21602

FAQ: How does Ignore NULL inputs for updates option work in Dynamic lookup transformation?

22439

FAQ: When is the "Ignore in Comparison" property available in a Lookup/Output port?

105995

FAQ: What are the .bak files generated in the Cache directory when you use "Re-cache from lookup source"?

21787

FAQ: What happens when a reusable dynamic lookup has new/updated rows and a session fails? How is the dynamic lookup affected?

20368

FAQ: Can an input port be used in the SQL Override query for a Lookup transformation?

10065

HOW TO: Override the Lookup ORDER BY clause generated by the PowerCenter session

102563

HOW TO: Avoid reuse of lookup cache by Lookup transformation with the same structure while using non persistent cache configuration

19426

FAQ: Can a PowerCenter session be configured to build lookup caches concurrently?

22530

HOW TO: Calculate the estimated cache sizes for a Lookup transformation in PowerCenter

23201

HOW TO: Parameterize Lookup Table Name in PowerCenter 8.5

16049

HOW TO: Run a PowerCenter session with a lookup override that contains a subquery

22863

HOW TO: Reduce the number of rows cached by Lookup Transformation to improve session performance

21386

HOW TO: Improve session performance by reducing disk swapping when using a Lookup transformation?

107919

HOW TO: Parameterize the lookup cache file name for a PowerCenter session

22655

HOW TO: Improve the performance of a PowerCenter session with a Lookup Transformation that has a Not Equal To condition and multiple conditions

17628

HOW TO: Improve performance of a session with a Lookup Transformation that has multiple conditions

11009

Lookup SQL Override Tips

16309

MAPPING TEMPLATES: Dynamic lookup caching

15174

Handling Multiple Matches from Lookups in PowerCenter mappings

15157

Using PowerCenter Lookup transformations with Ranges of Data

Router

The following is a list of articles that discuss the Router transformation:

Article ID

Title

17532

FAQ: Does the Router Transformation retain the order of the data?

13045

FAQ: What does Router transformation do if a row satisfies the condition of more than one output group?

Sequence Generator

The following is a list of articles that discuss the Sequence Generator transformation:

Article ID

Title

15008

FAQ: When running a PowerCenter session, how does a versioned Sequence Generator transformation update the current value?

16241

FAQ: Can the current value of the Sequence Generator be reset to the start value when copying a folder?

20133

HOW TO: Modify the values in a reusable Sequence Generator transformation

17250

HOW TO: Retrieve a list of Sequence Generator transformations in the repository using the repository views

16859

HOW TO: Retain and reuse Sequence Generator values when importing a new PowerCenter mapping

10734

HOW TO: Set a key value to start at the last value in a key field in the target table using a PowerCenter mapping

10697

HOW TO: Generate higher values than the maximum allowed by a Sequence Generator

20948

HOW TO: Use a query to determine the Sequence Generator values in a PowerCenter repository?

17164

A Sequence Generator does not generate sequential values for each PowerCenter session run

10919

HOW TO: Generate alphanumeric serial numbers using a PowerCenter mapping

Sorter

The following is a list of articles that discuss the Sorter transformation:

Article ID

Title

105582

FAQ: How to find the Sorter cache size and directory information in a PowerCenter repository?

107445

FAQ: What is the query to fetch the mapping which has Sorter transformation?

108466

HOW TO: Identify files used by the Sorter transformation

Source Qualifier

The following is a list of articles that discuss the Source Qualifier:

Article ID

Title

17657

FAQ: Can tables in different databases be used in a Source Qualifier transformation?

31292

FAQ: Does Pre-SQL use an Oracle session that is different than the select statement used in the Source Qualifier?

19611

HOW TO: Use a Stored Procedure as a source for a PowerCenter mapping

10861

HOW TO: Use $$$SessStartTime in a PowerCenter source qualifier SQL override

17863

HOW TO: Use SQL expressions in a Source Qualifier

11298

HOW TO: Create a SQL override based on tables from more than one database

15512

HOW TO: Validate SQL Override query using a database view

17501

HOW TO: Use a PowerCenter mapping variable in a SQL override

103327

FAQ: What is the size limit for a SQL Override in a PowerCenter mapping?

100604

FAQ: Can a SQL query or a source filter be used with a dynamic database source partition?

109331

FAQ: When is the Source Filter in the Source Qualifier applied in the PowerCenter session?

SQL

The following is a list of articles that discuss the SQL transformation:

Article ID

Title

107866

FAQ: What is the difference between "static query mode" and "dynamic query mode" in a PowerCenter SQL transformation?

23063

FAQ: How does the SQL Transformation commit data?

107931

FAQ: Can you execute a Stored Procedure using a SQL transformation?

21608

FAQ: Does each SQL Transformation open a new session with database?

20886

FAQ: What SQL construct does PowerCenter support with the SQL Transformation?

21332

FAQ: Can all Teradata Functions, Operators, Expressions and Predicates be used in a SQL Transformation?

101152

FAQ: Why is the "Is Active" option set for a SQL transformation created using script mode?

101096

HOW TO: Configure database resiliency for a SQL transformation

21080

HOW TO: Return the values of the Input ports of a SQL Transformation when no rows are returned by the result set

Stored Procedure

The following is a list of articles that discuss the Stored Procedure transformation:

Article ID

Title

20457

HOW TO: Ensure that Stored Procedure runs without error

11293

HOW TO: Execute a stored procedure only once when running a PowerCenter session

18430

HOW TO: Pass a PowerCenter mapping variable to a Stored Procedure transformation

21504

HOW TO: Call a Stored Procedure automatically when running a PowerCenter session

105541

HOW TO: Pass parameters containing single quotes to stored procedure in a PowerCenter mapping

10440

HOW TO: Change the execution order of unconnected Stored Procedure transformations in a PowerCenter mapping

Transaction Control

The following is a list of articles that discuss the Transaction Control transformation: 

Article ID

Title

15149

Using Transaction Control to Restart Failed PowerCenter Sessions

106106

FAQ: Can an Aggregator transformation be placed downstream of a "transaction control" transformation within a mapping?

31085

MAPPING TEMPLATE: Splitting a flat file using a Transaction Control transformation and the filename port

109888

FAQ: How does a TCT affect PowerCenter real-time sessions?

15652

HOW TO: Configure a PowerCenter session to commit target data on every row

23044

HOW TO: Fail a PowerCenter session and rollback all rows depending on a port condition

Union

The following is a list of articles that discuss the Union transformation:

Article ID

Title

15923

FAQ: Can duplicate rows be eliminated when using a Union transformation in a PowerCenter mapping?

Update Strategy

The following list of articles that discuss the Update Strategy transformation:

Article ID

Title

103867

Repository database query determine which mappings use an Update Strategy transformation

11551

FAQ: Are rejected rows written to the session log and reject file when a PowerCenter session is configured with the Forward Rejected Rows option?

16315

MAPPING TEMPLATES: Using Update strategy to delete rows

104061

HOW TO: Prevent writing DD_REJECT data to the PowerCenter session log



More Information


Reference


Attachments


Applies To
Product: PowerCenter
Problem Type:
User Type: Administrator
Project Phase:
Product Version:
Database:
Operating System:
Other Software:

Last Modified Date: 12/18/2014 6:45 PM ID: 109229
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)