Datastage is a comprehensive ETL Tool. Datastage used for the extraction, transformation and loading jobs for the data coming from different sources like db2, mainframe jobs, oracle databases etc. Datastage is a huge competitor etl tool in the market. Many companies are migrating to datastage because of its friendly in use. IBM Datastage is a comprehensive etl tool for all the job. It has different types of jobs with join stages, transformer stage, lookup stage, merge stage, aggregator stage sorting stage etc. Join stage is used to join different types joins. And it has different input requirements. Over the years most of the organizations have made significant investments in enterprise resource planning. Datastage parallel extender addresses these critical information.