1. What does JCL stands for?

a Job Control List

b Job Control Language
c Join Control Language
d Java Control Language

2. Process where hardware resources are shared by processor?

a Symmetric Multiprocessing
b Multitask Processing
c Massive Parallel Processing
d Parallel Processin

3 APT_CONFIG variable can identify which files ?

a *APT
b *apt
c *.apt
d *.apt_config

4 Which type is not used for lookups in data stage?

a Normal Lookup
b Dynamic Lookup
c Sparse Lookup

5 Which function is used to convert formats from one format to another

a LConv ()
b Conv ()
c IConv ()
d SConv ()

6 How do you find the number of rows in a sequential file?

a *.FINDROWNUM
b *INROWNUM
c *FINDROWNUM
d @INROWNUM

7 NLS stands for

a National Language System
b National Language Support
c National List System
d National Layer Support

8 Name the third party tool that can be NOT Used in data stage?
a Autosys
b TNG
c Event Co-ordinator
d DataStage Director

9 Which hash file is used to when limited amount of data is to be loaded in the
target database?
a Static Hash File
b Dynamic Hash File
c Multiple Hash File
d Normal Hash File

10 Which is type of view in data stage director?

a Section View
b Control View
c Status View
d Manage View

11 Which command is used to execute datastage job from command line prompt?
a datastagjob
b dsjob
c datajob
d djob

12 Which type is not used for Container?

b Shared Container
b Static Container
c Local Container

13 Which type of job is not used in datastage?

a Local Job
b Server Job
c Parallel Job
d Container Job

14 It is the internal scripting language of DataStage Engine.

a Shell Script
b OSH
c Scriptella
d All the above

15 this method is useful for resizing partitions of an input data set that are not
equal in size.

a Range
b Round Robin
c Hash
d Same

16 In Datastage 8.5, If a single XML document needs to be created with data from
multiple partitions, that XML Stage must be run in

a Combinability mode
b Parallel mode
c impersonation Mode
d sequential mode

17 How to run the dsjob in command prompt ?

a run dsjob <projectname> <jobname>

b $dsjob -run <projectname> <jobname>
c dsjob run <projectname> <jobname>
d $run -dsjob <projectname> <jobname>

18 In Datastage 8.5, If division operation has to be performed in Transformer

stage, What will be the output if Numerator is 1 and denominator is 0 ?

a Zero
b Infinity
c Null
d Job aborts
19 Impersonation mode is not applicable to ?

a UNIX
b LINUX
c WINDOWS
d ALL THE ABOVE

20 which action for lookup failure in lookup stage will send the row to reject
link Drop Continue Reject fail

a Drop
b Continue
c Reject
d fail

21 Output row only once option in Filter stage is

a Set to True to specify that rows are only output down the link of the first Where
clause they satisfy.

b Set to false to have rows output down the links of all Where clauses that they
satisfy.

c Set to true to output rows that satisfy no Where clauses down the reject link

A and B

22 Which of the following activities allows one to specify the name of the job the
activity is to run

a Exec Command Activity

b Job Actvity
c WaitforFile activity
d all of the above

23 Using Waitfor File Activity one can specify

a Wait for file to appear

b wait for file to disappear
c copy file to another location

24 Which of the following can be used to filter input dataset

a Sequential File Stage

b filter Stage
c transformer Stage

25 Which table action option in ODBC connector stage will diacard existing rows and
add new rows
a Create
b append
c truncate
d none of the above

26 execute command activity can be used to

a execute Operating system command
b batch command file
c executable

27 SCD stage has

a single input link, a single output link, a dimension reference link, and a
dimension update link

b single input link, a single output link, a reject link, and a dimension update
link

c single input link, a single output link, a dimension reference link, and a reject
link

28 The aggregator stage gives

a access to grouping and summary operations

b access to perform joining of input datasets
c access to perform union of input datasets
d none of the above

29 In which cases is the usage of sparse lookup appropriate ?

a Lookup on a flat file with sparse values

b Lookup on a database with sparse values
c Lookup on a large table Lookup on
d a table with few records

30 Which partitioning technique is appropriate for aggregator stage ?

a Random
b Round Robin
c Hash
d All the above

31 Which partitioning technique is appropriate for sorting duplicate records ?

a Hash
b Round Robin
c Random
d Range

32 Which property is used to read set of files ?

a Set READ METHOD property to File List
b Set READ METHOD property to File Pattern
c Set READ METHOD property to Directory
d none of the above

33 Which of the following partitioning method is key based ?

a Entire
b Round Robin
c Hash
d Random

34 Which of the following partitioning method does not require keys ?

a Hash
b Modulus
c Range
d Random
35 Which statements are true regarding Runtime Column Propogation in jobs

a A schema file is not required for flat file sources

b Only required columns are propogated to the target table
c Only columns required in data flow need to be specified
d Schema file is required for Database sources

36 Which stage allows multiple reject links ?

a Sort stage
b lookup stage
c Joiner stage
d Merge stage

37 Which of the following is true about Persistent DataSet ?

a Stores data in datastage internal format
b Data can be viewed using Dataset Viewer
c Dataset retains partitioning information
d All the above

38 Funnel Stage can have how many input links?

a Three
b Four
c Any Number
d one

39 Duplicate to Retain property in Remove Duplicate Stage can have which of the
following values?
a Only first record Only
b Last Record
c First/Last
d Any Record

40 Filter Stage will send the input dataset records that are not satified by any
where clause criteria to
a Reject link
b Other link
c Fail link
d None of the above

41 which of the following is not correct about loop stages?

a Used to build loops into your job

b sequences Has Numeric and List loop types in startloop activity
c All Stages between Start Loop Stage and End Loop Stage are included in loop
d End Loop activity has special properties

42 Which of the following is correct regarding Sequential file Stage?

a Is an Active stage
b Can have any number of reject links
c Cannot be used as Intermediate stage
d Is a processing stage

43 Types of Pivots supported in Pivot Enterprise Stage Only Horizontal Pivot a Only
Vertical Pivot
b Both Horizontal and vertical Pivot
c None of the above
44 Which partitioning technique is appropriate for RemoveDuplicate stage ? a Random

b Round
c Robin
d Hash

45 which of the following collecting methods Reads all rows from the first
partition, then all rows from the second partition, and so on
a ordered
b sequence
c Roundrobin
d None of the above

46 Which partitioning technique is often a preprocessing step to performing a

total sort on a data set?
Random
Modulus
Range
RoundRobin

47 Which Collection method of InfoSphere DataStage will read any row from any input
partition as it becomes available?
Auto
Round Robin
Continuous
sequence

48 What will happen when both inputs of JOIN stage are Round Robin Partitioned?

a Job will fail

b Output that gets generated will be always accurate
c OutPut that gets generated may be inaccurate
d Output that gets generated will be always inaccurate

49 If a dimension contains only Type 1 columns which purpose codes are allowed for
dimension columns on reference link

a Current Indicator
b Effective Date
c Expiration Date
d None of the above

50 Which of the following are options for UnMatched Master Mode property in Merge
Stage?

a keep
d Drop
c Reject
d A&B

51 Which of the following are funnel types in funnel stage?

a Sequence
b Sort
c Continuous
d All the above

52 Which of the following types of jobs can be run from Job Activity?
a Parallel job
b Sequence
c Server Job
d all of the above

53 Which one of following allows to branch the execution of a sequence depending on

a condition?

a Waitforfile Activity
b Nested Condition Activity
c Job Activity
d All the above

54 lookup sage is one of thee stages to join records based on value key

a join
b funeal
c merge
d difference

55 which type of data can be extreacted using unstructured stage

a xml
b excel
c biginsight hdfc file
d micosoft word

56 wich of the option is true when using dataset created using 4 node config file
a dataset is operating system file
b dataset is stored in non persistent format
c dataset controle file hold your data
d dataset stage con have one input link multiple output link

57 wich one is implecit data type conversion

a date to char
b char to date
c varchar to char
d char to timestamp

58 to run multiple copys of the same job in director wich of the following must
supplied

a job name
b invocation id
c parameter values
d username and password

59 which of the default data type in aggrigator stage during calculation

a integer
b double
c varchar
d decimal

60 which is not native operator in osh

a sort
b copy
c import
d generate
61 which one of the stage require schema file when using rcb

a sequqential file stage

b data set stage
c transformer stage
d merge stage

62 Which three of the following options does the dsjob command have? (Choose
three.)
A. Stopping a job
B. Setting an alias for a job
C. Specifying an appropriate log file
D. Listing projects,jobs,stages,links,and parameters

63 Which stages will require a schema file when runtime column propagation (RCP) is
enabled? (Choose two.)
A. Data Set
B. Column Import
C. Internal Source
D. External Target
E. Make Subrecord

63 Which of the following is NOT TRUE about the DataStage job score?

A. It includes the operators automatically inserted at runtime

B. It helps to determine the number of actual operating system processes
C. It reports the amount of memory used by the inter-operatortransport buffers
D. It outlines the connection topology between adjacent operators and persistent
data sets

64 By default, how much internal memory does the Sort use per partition?
A. 10MB
B. 20MB
C. 25MB
D. 30MB

65 a job read dataset using dataset stage, a data goes to transformer stage writes
to seqential file stage, default configuration file has 3 nodes file created data
set,and current job both uses same configuration file , how many instance of
transformer run in current job

a 2
b 1
c 3
d 4

66 Which stage support the dynamic defination of physical colums

A Sequential stage
B Colum Export Stage
C SCD stage
D Column Import Stage

67 Which three key less partition method

A Entair
B Modules
C Random
D Round Robin

68