Network
Data Engineering
Data Engineering Integration
Enterprise Data Catalog
Enterprise Data Preparation
Cloud Integration
Cloud Application Integration
Cloud Data Integration
Cloud Customer 360
DiscoveryIQ
Cloud Data Wizard
Informatica for AWS
Informatica for Microsoft
Cloud Integration Hub
Complex Event Processing
Proactive Healthcare Decision Management
Proactive Monitoring
Real-Time Alert Manager
Rule Point
Data Integration
B2B Data Exchange
B2B Data Transformation
Data Integration Hub
Data Replication
Data Services
Data Validation Option
Fast Clone
Informatica Platform
Metadata Manager
PowerCenter
PowerCenter Express
PowerExchange
PowerExchange Adapters
Data Quality
Axon Data Governance
Data as a Service
Data Explorer
Data Quality
Data Security Group (Formerly ILM)
Data Archive
Data Centric Security
Secure@Source
Secure Testing
Master Data Management
Identity Resolution
MDM - Relate 360
Multidomain MDM
MDM Registry Edition
Process Automation
ActiveVOS
Process Automation
Product Information Management
Informatica Procurement
MDM - Product 360
Ultra Messaging
Ultra Messaging Options
Ultra Messaging Persistence Edition
Ultra Messaging Queuing Edition
Ultra Messaging Streaming Edition
Edge Data Streaming
Knowledge Base
Resources
PAM (Product Availability Matrices)
Support TV
Velocity (Best Practices)
Mapping Templates
Debugging Tools
User Groups
Documentation
English
English
English
Español
Spanish
Deutsch
German
Français
French
日本語
Japanese
한국어
Korean
Português
Portuguese
中文
Chinese
Log Out
PowerCenter
10.2
10.5.2
10.5.1
10.5
10.4.1
10.4.0
10.2 HotFix 2
10.2 HotFix 1
10.2
H2L
Performance Tuning Guide
PowerCenter 10.2
PowerCenter 10.2
All Products
Rename Saved Search
Name
* This field is required
Overwrite saved search
Confirm Deletion
Are you sure you want to delete the saved search?
Table of Contents
Search
No Results
Preface
Performance Tuning Overview
Performance Tuning Overview
Bottlenecks
Bottlenecks Overview
Using Thread Statistics
Eliminating Bottlenecks Based on Thread Statistics
Example
Target Bottlenecks
Identifying Target Bottlenecks
Eliminating Target Bottlenecks
Source Bottlenecks
Identifying Source Bottlenecks
Using a Filter Transformation
Using a Read Test Mapping
Using a Database Query
Eliminating Source Bottlenecks
Mapping Bottlenecks
Identifying Mapping Bottlenecks
Eliminating Mapping Bottlenecks
Session Bottlenecks
Identifying Session Bottlenecks
Eliminating Session Bottlenecks
System Bottlenecks
Identifying System Bottlenecks
Using the Workflow Monitor to Identify System Bottlenecks
Identifying System Bottlenecks on Windows
Identifying System Bottlenecks on UNIX
Eliminating System Bottlenecks
Optimizing the Target
Optimizing Flat File Targets
Dropping Indexes and Key Constraints
Increasing Database Checkpoint Intervals
Using Bulk Loads
Using External Loaders
Minimizing Deadlocks
Increasing Database Network Packet Size
Optimizing Oracle Target Databases
Optimizing the Source
Optimizing the Query
Using Conditional Filters
Increasing Database Network Packet Size
Connecting to Oracle Database Sources
Using Teradata FastExport
Using tempdb to Join Sybase or Microsoft SQL Server Tables
Optimizing Mappings
Optimizing Mappings Overview
Optimizing Flat File Sources
Optimizing the Line Sequential Buffer Length
Optimizing Delimited Flat File Sources
Optimizing XML and Flat File Sources
Configuring Single-Pass Reading
Optimizing Pass-Through Mappings
Optimizing Filters
Optimizing Datatype Conversions
Optimizing Expressions
Factoring Out Common Logic
Minimizing Aggregate Function Calls
Replacing Common Expressions with Local Variables
Choosing Numeric Versus String Operations
Optimizing Char-Char and Char-Varchar Comparisons
Choosing DECODE Versus LOOKUP
Using Operators Instead of Functions
Optimizing IIF Functions
Evaluating Expressions
Optimizing External Procedures
Optimizing Transformations
Optimizing Aggregator Transformations
Grouping By Simple Columns
Using Sorted Input
Using Incremental Aggregation
Filtering Data Before You Aggregate
Limiting Port Connections
Optimizing Custom Transformations
Optimizing Joiner Transformations
Optimizing Lookup Transformations
Using Optimal Database Drivers
Caching Lookup Tables
Types of Caches
Enabling Concurrent Caches
Optimizing Lookup Condition Matching
Reducing the Number of Cached Rows
Overriding the ORDER BY Statement
Using a Machine with More Memory
Optimizing the Lookup Condition
Filtering Lookup Rows
Indexing the Lookup Table
Optimizing Multiple Lookups
Creating a Pipeline Lookup Transformation
Optimizing Normalizer Transformations
Optimizing Sequence Generator Transformations
Optimizing Sorter Transformations
Allocating Memory
Work Directories for Partitions
Unicode Mode
Optimizing Source Qualifier Transformations
Optimizing SQL Transformations
Optimizing XML Transformations
Eliminating Transformation Errors
Optimizing Sessions
Grid
Pushdown Optimization
Concurrent Sessions and Workflows
Buffer Memory
Increasing DTM Buffer Size
Optimizing the Buffer Block Size
Caches
Limiting the Number of Connected Ports
Cache Directory Location
Increasing the Cache Sizes
Using the 64-bit Version of PowerCenter
Target-Based Commit
Real-time Processing
Flush Latency
Source-Based Commit
Staging Areas
Log Files
Error Tracing
Post-Session Emails
Optimizing Grid Deployments
Optimizing Grid Deployments Overview
Storing Files
High Bandwidth Shared File System Files
Low Bandwidth Shared File System Files
Local Storage Files
Using a Shared File System
Configuring a Shared File System
Balancing CPU and Memory Usage
Configuring PowerCenter Mappings and Sessions
Distributing Files Across File Systems
Configuring Sessions to Distribute Files
Guidelines for Parameter Files and Scripts
Examples
Optimizing Sequence Generator Transformations
Optimizing the PowerCenter Components
Optimizing the PowerCenter Components Overview
Optimizing PowerCenter Repository Performance
Location of the Repository Service Process and Repository
Ordering Conditions in Object Queries
Using a Single-Node DB2 Database Tablespace
Optimizing the Database Schema
Object Caching for the Repository Service
Optimizing Resilience
Optimizing Integration Service Performance
Using Native and ODBC Drivers
Running the Integration Service in ASCII Data Movement Mode
Caching PowerCenter Metadata for the Repository Service
Optimizing the System
Optimizing the System Overview
Improving Network Speed
Using Multiple CPUs
Reducing Paging
Using Processor Binding
Using Pipeline Partitions
Using Pipeline Partitions Overview
Increasing the Number of Partitions
Selecting the Best Performing Partition Types
Using Multiple CPUs
Optimizing the Source Database for Partitioning
Tuning the Database
Grouping Sorted Data
Optimizing Single-Sorted Queries
Optimizing the Target Database for Partitioning
POWERCENTERHELP
POWERCENTERHELP.CHM
Performance Tuning Guide
Performance Counters
Performance Counters Overview
Errorrows Counter
Readfromcache and Writetocache Counters
Readfromdisk and Writetodisk Counters
Rowsinlookupcache Counter
Performance Tuning Guide
Performance Tuning Guide
10.2
10.5
10.4.0
Back
Next
Reducing the Number of Cached Rows
Reducing the Number of Cached Rows
You can reduce the number of rows included in the cache to increase performance. Use the Lookup SQL Override option to add a WHERE clause to the default SQL statement.
Caching Lookup Tables
Updated August 06, 2018
Download Guide
Send Feedback
Resources
Communities
Knowledge Base
Success Portal
Back to Top
Back
Next
