Null_Handling

Datatype conversion

move or keep column

None of the Above

All the Above

count,calculation,recalculation

Sort and Hash

count, sum, Average

None of the Above

Normal

Sparse

Both

None of the Above

Datastage Designer

Datastage Administrator

Install the Datastage engine

All the Above

Only to extract data

Only to load data

Only either to extract or to load

Only to Transform data

To extract, load or transform

File path

File format (Fixed width or Delimited)

Column definitions

None of the above

Constraints

Derivations

Column Mappings

All of the above

At Compile time

At Run time

At Both compile time and run time

Never

Shared container

Local container

Both

None of the above

DataStage Designer and Administrator

DataStage Administrator

DataStage Designer

None of the above

Aggregator stage

Change Capture stage

Modify stage.

Change Apply stage

Number of Processes or Nodes.

Actual Disk Storage Location.

Fast name

All the Above

Range

Same

Round Robin

None of the above

dsjob -run -jobstatus projectname jobname

dsjob -run projectname jobname

dsjob -exec projectname jobname

dsjob -exec –jobstatus projectname jobname

Micky

Jhon

None of the above

" String with whitespace "

Stringwithwhitespace

"String with whitespace "

" String with whitespace"

Transformer

File

Row Generator

Peek

File

Aggregator

Transformer

All of the above

Read From Multiple Nodes

Number of Readers Per Node

Report Progress

Pattern

2G limit on some File systems

Need to distribute data among nodes to prevent overruns

If used in parallel, runs faster than sequential file

No limitations for the File systems