Datastage Performance Tuning

Performance Tuning in ETL (Datastage) can be done in 3 different levels -

Architecture Level 

Information Server Architecture

Installation settings
Project level settings

Configuration File

ETL Design Level

            ETL design guidelines

                        Extraction

                        Transformation

                        Load

            ETL best practices

            ETL strategies for known problems

Datastage Job Level

            Parallel Stages best practices

                        Extraction
                        Transformation
                        Load

            Partitioning and Sorting