IBM InfoSphere DataStage Online Test

Topics covered

Connector Stage, DataStage Engine, Aggregate Stage, DatatStage 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 hiring 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

  • DatatStage 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

20 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: David Messi Test Date: 28-May-2014
Test Name: IBM InfoSphere DataStage Test Test Start Time: 13.30

Score: 18 Out Of 20

Percentage: 90

Result: PASS

passing score image
Section Name FAIL PASS
IBM Infosphere DataStage
Score: 18/20
Strength IBM Infosphere DataStage
Weakness -
* Note: If score <= 40 then its a Weakness. If score >= 80 then its a Strength.
10 20 30 40 50 60 70 80 90 100%
Tolerable Limit Not acceptable
Window Violation: 0 | Time Violation: 0 secs
Gender : Male Phone Number : +1-541-754-3010
Total Experience (Years) : 3 Total Experience (Months) : 5
Skill Set : IBM Infosphere DataStage Current Employer : Interview Mocha
Current Job Title : Solution Architect Current Salary : 600.00
Expected Salary : 1000000.00 Current Location : Chicago

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.


Schedule a Demo

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
  • hexaware
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

Sign up for a free trial today

Get your free trial and test up to 10 candidates. No strings attached. No credit card required.


Schedule a Demo