Datastage is an Extract, Transform and Load ( ETL ) tool from IBM and part of their IBM InfoSphere. Here I have collected more than 70 interview questions with their answers about Datastage. Download Complete IBM Datastage Interview questions PDF. All these questions are frequently asked ones and better prepare all these before attending your Datastage interview . You can also refer Datastage Tutorials and PDF training materials.
DataStage is “ETL tool, which extracts data, transforms it and applies business rules and then loads it to any target.” According to Wikipedia, “IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition.”
- Prepare for this first question very well. Introduction about IBM Datastage tool
- There are mainly two tools used for the same purpose. Informatica and Datastage. Let us prepare the main difference bewteen these two ETL tools
- A sure questions ie about the main components of datastage
- Question about System variables
- About Merage
- About Sequencers
- Introduction about version COntrol in Datastage
- Another important Datastahe interview question about Active Stage and Passive stage
- Question about Datastage features
- About Data aggregation
Which Tool is best from Informatica & Datastage ? I need to know the scope to start my career. Which tool is used by more companies and have more job vacancies ? I am planning to do some training on any of these ETL tool .