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


"Finding quality talent is a challenge more so when you consider the sheer number of resumes we get each year. To top this, the time we spent on our recruitment process was humongous. Interview Mocha helped us to cut down on our candidate filtration time by 40%, making it our preferred assessment tool."

Pedro Furtado, Altran,
Capacity 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

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