IBM InfoSphere DataStage Online Test

Topics covered

Connector Stage
DataStage Engine
Aggregate Stage, DataStage Functions
Transformer Stage

  • MAQ (Multiple Answer Question)
  • MCQ (Multiple Choice Question)
  • Descriptive Question
  • White Board Simulator
  • Coding Simulator
  • Audio Question
  • Video Question
  • Case Study Question

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.

This pre-employment test is useful for hiring:
  • DataStage Developers
  • DataStage Consultant

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.

IBM InfoSphere DataStage Test

Question #1 of 3

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

Question #2 of 3

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

Question #3 of 3

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

Candidate Name
Assessment Name
Invited by
Assessment Date
IP Address

24.00 Out of 40.00
23 Minutes

Java EE




Oracle PL/SQL


Analytical Thinking


Note:If score<= 30% then its a Weakness. If score >=70% then its a Strength.


Java EE, Oracle PL/SQL, Analytical Thinking




It was a good test for me, the questions were on the latest technology of java on which I am currently working. It was a great experience. Thank you!

Take your first step to hire job fit candidate


How Interview Mocha works?

  • Add this test to your account

  • Invite candidates to take this test online

  • Candidates take the test

  • View and share actionable test reports

Trusted by leading brands worldwide

  • altran
  • credit suisse
  • sephora
  • nielsen
  • capgemini
  • akamai
Why hiring managers and recruiters across the globe love Interview Mocha
  • Largest number of ready pre-employment skill tests
  • Relevant test compositions and quality questions designed by Subject Matter Experts (IM SME)
  • Fastest custom test creation DNA
  • World’s most super easy skill assessment platform
  • High level of platform security implementation
  • Friendly and quick customer support
  • Ready to listen and implement your feedback, we are all ears
  • Affordable pricing

Take your first step to hire job fit candidate