>
SQL
Programming
DataStage Knowledge Test
Verifies knowledge of IBM DataStage, the ETL tool: components, job types, stages and containers, plus data warehouse concepts, in 20 questions and 30 minutes.
Difficulty
Intermediate
20
questions
Time limit of
30
mins
English
About this test
A knowledge test with no coding: 20 questions on how DataStage jobs are designed and administered, and on the dimensional modeling ideas behind them. Intermediate level. It checks what the candidate knows about DataStage, not whether they can build a job from scratch; for that, combine it with a technical interview.
What it measures
The Administrator and Director components and how the Director window is organized
Job types, server components and container types
Stages and which one represents sources, targets and aggregation
Locales, maps and link partitioners
Hash files and converting columns into rows
Dimension and fact table concepts, including additive facts
Ideal for
ETL developers
Data warehouse and BI roles
Screening DataStage knowledge at an intermediate level
Details
Programming
Difficulty
Intermediate
Time limit of
30
mins
SQL
English
20
questions
Average duration:
0
min
3
times completed