Data Stage Testing Questions and Answers

Data Stage | Testing | Mock Test

1
_____ stage is useful to read from excel file?
a. Sequential file
b. Complex flat file
c. ODBC
d. Datastage Admistrator

Answer : ODBC

2
Data Stage Configuration tasks are carried out by
a. Data Stage Administrators
b. Data Stage Directors
c. Data Stage Designers
d. Database Tables
Answer : Data Stage Administrators

3
DataStage allows to define your own stage types using ________________, which can be uses in parallel jobs
a. Datastage Director
b. Datastage Designer
c. Datastage Manager
d. COBAL
Answer : Datastage Manager

4
Datastage Log files are held in
a. Sequential files
b. Hash files
c. Datasets
d. Transporter
Answer : Hash files

5
Datastage Native operators are developed in
a. C ++
b. C
c. BASIC
d. by killing the respective PORT ID
Answer : C ++

6
How do u convert the columns to rows in Data Stage
a. Using Excel sheets
b. Using Pivot Stage
c. Using Sequential load generator
d. Cant Say
Answer : Using Pivot Stage

7
How to kill the job in data stage
a. Restart the server
b. by killing the respective process ID
c. by killing the respective Job ID
d. APT configuration file
Answer : by killing the respective process ID

8
In a parallel job scenario, more nodes means better performance.
a. Yes
b. No
c. Depends
d. Link Administrator
Answer : Depends

9
——–is the parameter that defines the number of ways of parallelism of a given job.
a. Parameter File
b. Sequential File
c. Hash File
d. APT configuration file
Answer : APT configuration file

10
It actually splits data into various partitions or data flows using various Partition methods
a. Link Partitioner
b. Link Collector
c. Link Director
d. Link Administrator
Answer : Link Administrator