IBM InfoSphere DataStage Online Test to Assess DataStage Expert

Topics Covered

Connector Stage

This IBM InfoSphere DataStage online test helps recruiters and hiring managers to evaluate candidate’s understanding about connector stage which helps to access external data source

DataStage Engine

Our test assesses applicant’s knowledge about DataStage engine which helps users to connect to the server engine by using Telnet

Aggregate Stage

This assessment checks applicant’s knowledge about aggregate stage which helps to give access for grouping and summary operations

DataStage Functions

iMocha’s IBM InfoSphere DataStage skills test evaluates candidate’s understanding about DataStage functions that performs a specific task to return values

Transformer Stage

This assessment checks applicant’s knowledge about Transformer Stage that allows to transform the data

Sample Questions

Choose from our 100,000+ question library or add your own questions to make powerful custom tests

Question types:

Multiple Answer

Topic:

-

Difficulty:

Easy

Q 1. 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 types:

Multiple Answer

Topic:

-

Difficulty:

Easy

Q 2. 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 types:

Multiple Option

Topic:

-

Difficulty:

Easy

Q 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

You can customize this test by

Setting difficulty level of test

Choose easy, medium or hard questions from our skill libraries to assess candidates of different experience levels.

Combining multiple skills into one test

Add multiple skills in a single test to create an effective assessment. Assess multiple skills together.

Adding your own questions to the test

Add, edit or bulk upload your own coding questions, MCQ, whiteboarding questions & more.

Requesting a tailor-made test

Get a tailored assessment created with the help of our subject matter experts to ensure effective screening.

Trusted By

Pedro Furtado, Capacity Manager, Altran-Portugal

“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. iMocha helped us to cut down on our candidate filtration time by 40 %, making it our preferred assessment tool.”

IBM InfoSphere DataStage Online Test

24152+

123+

About IBM InfoSphere DataStage Online Test

Test Summary

Useful for hiring

Topics Covered

Connector Stage

DataStage Engine

Aggregate Stage

DataStage Functions

Transformer Stage

Sample Questions

Sample Report

Hire job-fit candidates using this test now

You can customize this test by

Setting difficulty level of test

Combining multiple skills into one test

Adding your own questions to the test

Requesting a tailor-made test

Related Skills

Trusted By

Pedro Furtado, Capacity Manager, Altran-Portugal

Start hiring job-fit candidates using this assessment