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

Have any Question or Comment?

Leave a Reply

Exciting Offers

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 90 other subscribers

Exciting Offers

Exciting Offers

Exciting Offers

Close
%d bloggers like this: