IBM InfoSphere DataStage v11.3

XML data ✘ Microsoft Word data ✘ Microsoft Excel data ✘ BigInsights HDFS file data ✔

Each environment must have a C++ compiler. ✘ QualityStage rule sets are not a type of deployable asset. ✘ It is not possible to revert to a previous version of a package. ✘ A package can contain an improved version of a job which will replace the old one. ✔

Data sets are operating system files ✘ Data is stored in a non-persistent form ✘ The data set control file holds all your data ✘ A Data Set stage can have 1 input link and multiple output links ✔

Conductor, section leader and player processes are executed on the server is1 and is2. ✘ Conductor process is executed on the server is1. Section leader and Player processes are executed on the server is2. ✘ Conductor and section leader processes are executed on the server is1. Player processes are executed on the server is2. ✘ Conductor process and player processes are executed on the server is1. Section leader process is executed on the server is2. ✔

On two physical nodes and two logical nodes ✘ On two physical nodes and single logical node ✘ On a single physical node and two logical nodes ✘ On a single physical node and single logical node ✔

date -> char

✘

char -> date

✘

varchar -> char

✘

char -> timestamp

✔

A job must have zero or one ISD input stages ✘ A job with an ISD input stage must have an ISD output stage ✘ Buffer size and timeout values can be supplied as job parameters ✘ Text over JMS binding is only available if you are using Network Deployment ✔

$OSH_PRINT_SCHEMAS ✘ $APT_RECORD_COUNTS ✘ $APT_PARTITION_COUNT ✘ $APT_DEBUG_OPERATOR ✔

A Modify Operator is inserted at run time before a Transformer stage to handle null values ✘ If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column contains a null. ✘ If an input column that is used in the derivation expression of an output column contains a null value, then that row will be dropped or, if a reject link had beendefined, rejected ✘ If an input column that is used in the derivation expression of an output column contains a null value, then the resulting output column will be calculated ignoringthe Null value. ✔

Integer ✘ Double ✘ VarChar ✘ Decimal ✔