Table of Contents

Search

  1. Preface
  2. Performance Tuning Overview
  3. Bottlenecks
  4. Optimizing the Target
  5. Optimizing the Source
  6. Optimizing Mappings
  7. Optimizing Transformations
  8. Optimizing Sessions
  9. Optimizing Grid Deployments
  10. Optimizing the PowerCenter Components
  11. Optimizing the System
  12. Using Pipeline Partitions
  13. POWERCENTERHELP
  14. Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Examples

Examples

In the following excerpt of a raw parameter file, the placeholder “{fs}” represents the file system where the directory is located and must be assigned by a script before being used:
[SessionFFSrc_FFTgt_CA] $InputFile_driverInfo_CA={fs}/driverinfo_ca.dat $SubDir_processed_CA={fs} # Session has Output file directory set to: # $PmTargetFileDir/$SubDir_processed_CA # This file is the input of SessionFFSrc_DBTgt_CA. $SubDir_RecordLkup_Cache_CA={fs} # This session builds this persistent lookup cache to be used # by SessionFFSrc_DBTgt_CA. # The Lookup cache directory name in the session is set to: # $PmCacheDir/$SubDir_RecordLkup_Cache_CA [SessionFFSrc_FFTgt_NY] $InputFile_driverInfo_NY={fs}/driverinfo_ny.dat $SubDir_processed_NY={fs} [SessionFFSrc_DBTgt_CA] $SubDir_processed_CA={fs} # session has Source file directory set to: # $PmTargetFileDir/$SubDir_processed_CA $SubDir_RecordLkup_Cache_CA={fs} # Use the persistent lookup cache built in SessionFFSrc_FFTgt_CA.
In the following parameter file excerpt, a script has replaced the placeholder with the appropriate file system names, such as file_system_1 and file_system_2:
[SessionFFSrc_FFTgt_CA] $InputFile_driverInfo_CA=file_system_1/driverinfo_ca.dat $SubDir_processed_CA=file_system_2 # Session has Output file directory set to: # $PmTargetFileDir/$SubDir_processed_CA # This file is the input of SessionFFSrc_DBTgt_CA. $SubDir_RecordLkup_Cache_CA=file_system_1 # This session builds this persistent lookup cache to be used # by SessionFFSrc_DBTgt_CA. # The Lookup cache directory name in the session is set to: # $PmCacheDir/$SubDir_RecordLkup_Cache_CA [SessionFFSrc_FFTgt_NY] $InputFile_driverInfo_NY=file_system_2/driverinfo_ny.dat $SubDir_processed_NY=file_system_1 [SessionFFSrc_DBTgt_CA] $SubDir_processed_CA=file_system_1 # session has Source file directory set to: # $PmTargetFileDir/$SubDir_processed_CA $SubDir_RecordLkup_Cache_CA=file_system_2 # Use the persistent lookup cache built in SessionFFSrc_FFTgt_CA.