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. Appendix A: Performance Counters

Performance Tuning Guide

Performance Tuning Guide

Guidelines for Parameter Files and Scripts

Guidelines for Parameter Files and Scripts

When you create parameter files and scripts, use the following guidelines:
  • To easily maintain flexibility and control of session file locations, use a script to replace placeholders in a parameter file.
  • Consider the estimated file size and file system capacity when you define file locations.
  • Avoid organizing files according to business logic if the sessions and workflows need to access business-related files at the same time. For example, if you store California files on one file system and New York files on another, a bottleneck might occur if the session needs to access both files at the same time.
  • When possible, place files for different partitions of the same source, target, or lookup on different file systems.

0 COMMENTS

We’d like to hear from you!