Are you a candidate looking to sharpen your skills? Try our practice tests or view sample interview questions & Get hired by the best. Click Here×

IBM InfoSphere DataStage Online Test

Topics Covered

  • Connector Stage
  • DataStage Engine
  • Aggregate Stage
  • DataStage Functions
  • Transformer Stage

Useful for hiring

  • DataStage Developers
  • DataStage Consultant

Start hiring job-fit candidates using this assessment


"We are impressed with Interview Mocha's comprehensive IT skill test batteries and their ability to provide tailor-made assessments quickly. The results we got from Interview Mocha exceeded our expectations, employees found the tests quick, fun, and a benchmark of their knowledge."

Ajay Garg, Siemens,
Associate Manager

In a parallel job that is extracting data from Oracle table, below error is encountered:
"oci_oracle_source: When checking operator: When binding output interface field "ColumnA" to field "ColumnA": Converting a nullable source to a non-nullable result"

How will you handle this?

Note: There can be multiple correct answers to this question.

    • Handle the nulls in extracting sql query

    • Change the column to nullable 

    • None of the mentioned


After the jobs are successfully tested in the lower environment, we have to export them so as to promote them to the higher environment. Which of the following components requires to be exported in the dsx file?

Note: There can be multiple correct answers to this question.

    • parallel and sequence jobs

    • datasources

    • parameter sets

    • None of the mentioned


An oracle connector stage that reads input from a healthcare company database has the date in Julian format. Datastage has to transform the data and load to integration hub located on a different server with specific date format. Which function will you use in transformation stage to convert Julian date to a date of format yyyy-mm-dd?

    • DateFromJulianDay

    • JulianDaytoDate

    • JulianToDate

    • DateFromJulianDate

Test details:

Identify & hire DataStage developers by evaluating working skills and job readiness of the candidates with our scientifically designed IBM InfoSphere DataStage pre-employment test.

This test contains MCQ's (Multiple Choice Questions), MAQ's (Multiple Answer Questions), Fill in the Blank, Descriptive, True or False.

Test Details: 20 minutes

10 Application Questions

The combination of application questions helps to evaluate technical as well as practical skills of candidates.

Test description:

IBM InfoSphere DataStage Online Test is specially designed by subject matter experts to check application skills of DataStage Experts – as per Industry Standards.

IBM InfoSphere DataStage is an ETL tool which is a part of the IBM Information Platforms Solutions suite and IBM InfoSphere. DataStage 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.

IBM InfoSphere DataStage skills Test helps to hire managers & recruiters to validate the DataStage skills of an applicant before an interview.

The IBM InfoSphere DataStage assessment test contains questions on following Topics:

  • Connector Stage

  • DataStage Engine

  • Aggregate Stage

  • DataStage Functions

  • Transformer Stage

Using powerful reporting, you can have a detailed analysis of the IBM InfoSphere DataStage quiz test results to help you make a better hiring decision and predict the candidate’s performance.

Good News! You can customize this test as per your requirement

  • Choose and add questions from Interview Mocha question libraries

  • Add your own set of questions

  • Customize test settings like duration, number of questions, passing score, web proctoring and much more

  • Mail us at to create a custom test

Looking for a tailor-made test, to suit your assessment needs?

Get in touch

Global companies using Mocha assessments

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai

How Mocha assessments are brewed

Speed up your IT recruitment with Interview Mocha

  • 500+ IT skill tests
  • 20+ coding languages
  • 50+ domain knowledge tests
  • 100+ digital 2.0 skill tests
  • Customer focus aptitude tests
  • Enterprise ready features & more...

Why hiring managers and recruiters across the globe love Interview Mocha

Take your first step to hire job fit candidates