Data Stage Intermediate Quiz

Posted on: | By: – Comments Off

Data Stage Intermediate Quiz




Data Stage Intermediate Quiz contains set of 103 Data Stage MCQ Questions With Answers which will help you to clear Intermediate level quiz.




1) Deletion code generated in change capture when the

  1. Record which present only in before dataset not in After dataset
  2. Records which present only in after datset not in before dataset
  3. Record present in both the datasets
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

2) Change capture stage contains two input links as

  1. previous and current
  2. history and delta
  3. before and after
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

3) What are the characteristics of the containers

  1. Containers are used to execute jobs.
  2. Containers are a group of stages and links.
  3. Containers are used to stop jobs
  4. Containers allow multiple users to access a single job.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

4) Which one is the type of view in Datastage Director?

  1. Job View
  2. Log View
  3. Status View
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

5) What does the ERROR 81021 Calling subroutine DSR_RECORD ACTION=2 mean and the solution is?

  1. It means when a job sequence is used and it contains many stages (usually more than 10) and very often when a network connection is slow and the solution is to redesign the whole job
  2. Error means that the source records are bad and the job needs a restart
  3. It is due to the communicaiton failure between DataStage client and server. First try to complie by using explicit login to Datastage Designer if problem still persist then execute DS.REINDEX ALL command from the Datastage shell.
  4. Job has failed with the error 81021 due to large volumes of data processing and the solution is to split the source records into multiple threads

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

6) Encode stage, contains maximum how many links

  1. 3
  2. 10
  3. 1
  4. 0

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

7) Environment variable which needs to be set to debug the run time environment

  1. $OSH_PRINT_DROPPED_COLUMNS
  2. $OSH_PRINT_SCHEMAS
  3. $OSH_SHOW_COMPONENT_CALLS
  4. $OSH_SHOW_STARTUP_STATUS

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

8) Environment variable that needs to be set for compiling the datastage job

  1. APT_LINKER
  2. APT_PM_DBX
  3. APT_LINKEROPT
  4. APT_COMPILER

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

9) Which environment variable,when set to true,causes a report to be produced which shows the operators,processes and data sets in the job?

  1. APT_DUMP_SCORE
  2. APT_JOB_REPORT
  3. APT_MONITOR_SIZE
  4. APT_RECORD_COUNTS

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

10) What does setting an environment variable, specified as a job parameter, to PROJDEF do?

  1. Populates the environment variable with the value of PROJDEF.
  2. Explicitly unsets the environment variable.
  3. Uses the value for the environment variable as shown in the DataStage Administrator.
  4. Uses the current setting for the environment variable from the operating system.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

11) what is meaning of file extender in data stage server jobs?

  1. File extender means adding a new file to an already existing file in datastage
  2. File extender means adding only records to an already existing file in datastage
  3. File extender means adding columns or records to an already existing file in datastage
  4. File extender means adding only columns to an already existing file in datastage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

12) Select the correct statement

  1. Remove duplicate stage having reject link
  2. Filter stage having reject link
  3. Both A and B
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

13) What Stage is used to read a flat file with pipe delimited.

  1. File lookup Stage
  2. sequential Stage
  3. Complex Flat File Stage
  4. Transformer Stage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

14) Debug menu is available for

  1. Server Jobs
  2. Parallel Jobs
  3. Shared Containers
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

15) Which statement is not true from following

  1. Annotations can be used in server and parallel job but not in mainframe jobs
  2. Annotations can be used in server and parallel job but not in shared containers
  3. Annotations can be used only in server job
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

16) Variable used to set the directory to write the build op code

  1. OSH_BUILDOP_OBJECT
  2. OSH_BUILDOP_XLC_BIN
  3. OSH_BUILDOP_CODE
  4. A&C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

17) Degree of Parallelism is DataStage job is defined by

  1. Logical nodes configured in the config file
  2. No of nodes in the hardware
  3. Job Run time Parameters
  4. Target Database

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

18) Is direct lookup possible using DB2 enterprise stage

  1. Yes
  2. No

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

19) A left outer join can be implemented by

  1. Join Stage
  2. Lookup Stage
  3. Join or Oracle stage
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

20) what does deletion of a dataset from                        “DataStage designer -> Tools -> DataSet Management” do?

  1. Deletes the control file only
  2. Deletes the dataset file at the server only
  3. Deletes both the control and server files
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

21) Datastage jobs can be exported in .XML file as well as in .DSX file

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

22) Datastage Native operators are developed in

  1. C ++
  2. C
  3. BASIC
  4. COBAL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

23) Loading Data into Teradata tables is achieved by

  1. ODBC Stage
  2. Teradata API
  3. JAVA API
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

24) Job Version Control can be achieved by

  1. Versioning Tools
  2. Versioning feature available within the Tool
  3. Both
  4. None of the Above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

25) Which two tasks will create DataStage projects

  1. Install the DataStage engine
  2. Copy a project in DataStage Administrator
  3. Add new projects from DataStage Administrator
  4. Both A and C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

26) Which three lookup types may be performed in the Lookup stage?

  1. Equality match
  2. Range on stream link
  3. Range on the reference link
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

27) Which Oracle Enterprise stage read property can be set using db options to tune job performance?

  1. memsize
  2. arraysize
  3. partitionsize
  4. transactsize

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

28) Which two stages allow reject links?

  1. Join stage
  2. Merge stage
  3. Lookup stage
  4. Both B & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

29) You would like to compare two versions of a job that has been copied and renamed. How would
you proceed?

  1. Use Advanced Find to locate job duplicates.
  2. Use the Compare against feature
  3. Verify the properties of the job for the version.
  4. Perform a check sum on an export of the job.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

30) Which two statements describe both File Sets and Data Sets?

  1. File and Data Sets preserve partitioning.
  2. File and Data Sets are stored in internal format
  3. File and Data Sets contain header file and data files
  4. Both A & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

31) Which stage does not require sorted input?

  1. Join stage
  2. Merge stage
  3. Lookup stage
  4. Remove Duplicates stage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

32) Which partitioning method requires specifying a key

  1. DB2
  2. Entire
  3. Modulus
  4. Random

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

33) What is descriptor file in dataset stage?

  1. It contains the description of data file
  2. It contains the data file
  3. It contains the address of data file
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

34) What is data file in dataset stage ?

  1. Data File contains the data in native format
  2. Data File contains the configuration data
  3. It contains the address of dataset
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

35) What is OConv () function and where is it used?

  1. OConv is used to convert only date into internal format
  2. OConv is used to convert only date into user understandable format
  3. OConv is used to convert the system understandable format to user understandable format
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

36) What is IConv () function and where is it used?

  1. IConv is used to convert only date into internal format
  2. IConv is used to convert the input to system understandable format
  3. IConv is used to convert only date into user understandable format
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

37) What is NLS in datastage? how we use NLS in Datastage ?

  1. NLS stands for no language support. It is used for excluding other country languages like French, German, Spanish, etc.
  2. NLS stands for national language support. It is used for including other country languages like French, German, Spanish, etc(whose scripts are similar to English) in the data that is processed
  3. NLS stands for neutral library support. It is used to support the system library functions used for other country languages like French, German, Spanish, etc.
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

38) What is the link partitioner in datastage job?

  1. It’s used for partition parallelism
  2. It’s used for pipeline parallelism
  3. The Link Partitioner stage is an active stage which takes one input andallows you to distribute partitioned rows to up to 64 output links. It’s used in DataStage Server Jobs.
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

39) What is Modulus in Dynamic Hashed File?

  1. If the size of the file remains same it is called as “Modulus”
  2. If the size of the file increases it is called as “Modulus”
  3. If the size of the file decreases it is called as “Modulus”.
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

40) What is Splitting in Dynamic Hashed File?

  1. If the size of the file remains same it is called as “Splitting”.
  2. If the size of the file increases it is called as “Splitting”.
  3. If the size of the file decreases it is called as “Splitting”.
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

41) Link Partitioner enables to run server jobs in parallel but needs MPP system

  1. TRUE
  2. False

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

42) Enable hashed file cache sharing can be used to

  1. Run multiple instances of a job
  2. Enable multiple processes to access the same hash file in cache
  3. Save memory resources and speed up execution
  4. Both B & C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B, C[/bg_collapse]

43) Comments in routine should begin with

  1. REM
  2. * (Start Sign)
  3. ! (Exclamation Sign)
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

44) Which one is correct from below:

  1. IF X THEN
  2. A = B; REM The rest of this line is a comment; B = C
  3. END
  4. IF X THEN
  5. A = B; REM The rest of this line is a comment
  6. B = C
  7. END
  8. IF X THEN
  9. A = B; * The rest of this line is a comment; B = C
  10. END
  11. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

45) Server Job compiles successfully but doesn’t run because

  1. Job has not been compiled with compatible compiler
  2. Job design have cyclic dependencies within a sequence of active stages
  3. Configuration file is missing from Datastage server
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

46) Which of the below statement is not true when a Datastage job is validated, :

  1. Connections are made to the data sources or data warehouse for server jobs
  2. Parallel job runs in ‘check only’ mode so data is not affected
  3. Intermediate files are create
  4. A
  5. B
  6. C
  7. D

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

47) Parameter Sets provide an easier and faster method to add parameters to a job, eliminating the need to add parameters invidiually to each job.

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

48) Which of the following statement is incorrect:

  1. We can take an export of Data Stage job executable in DSX format.
  2. We can take an export of Data Stage job executable in XML format.
  3. We can take an export of Data Stage job executable in pdf format.
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

49) What is Modulus and Splitting in Dynamic Hashed File

  1. Modulus – Increasing the file Size
  2. Splitting – Decreasing the file size
  3. Modulus – Decreasing the file Size
  4. Splitting – Increase the file size
  5. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

50) Size of read cache of a hash file can be set to the value between

  1. 0-256 MB
  2. 0-1024 MB
  3. 0-999 MB
  4. 0 – 2048 MB

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

51) What are the two types of hashed files?

  1. Static and Dynamic
  2. Generic and Specific
  3. Static and Specific
  4. Generic and Dynamic

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

52) One of the below join option is not available in Join stage

  1. Self join
  2. Inner join
  3. Left outer join
  4. Full outer join

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

53) Which one is false statement about the Join stage?

  1. All the inputs to the Join stage must be sorted by the Join key.
  2. Join stages can have reject links that capture rows without matches
  3. The Join stage supports inner, left outer, and right outer joins.
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

54) How does a Join stage process an Inner join?

  1. It transfers all values from the right data set and transfers values from the left data set and intermediate data sets only where key columns match.
  2. It transfers records from the input data sets whose key columns contain equal values to the output data set.
  3. It transfers all values from the left data set but transfers values from the right data set and intermediate data sets only when key columns match.
  4. It transfers records in which the contents of the key columns are equal from the left and right input data sets to the output data set. It also transfers records whose key columns contain unequal values from both input data sets to the output data set.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

55) Number of input links that a merge stage can accepts

  1. 1
  2. 3
  3. 2
  4. n

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

56) Which feature does the Merge stage have that is not available in the Join and Lookup stages?

  1. All inputs must be sorted.
  2. Input data may be unsorted.
  3. Several reject links may be specified
  4. No more than one reject link may be specified.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

57) A DataStage job contains a parallel Transformer with a single input link and a single output link. The Transformer has a constraint that should produce 1000 records,however only 900 came out through the output link. What should be done to identify the mis

  1. Scan generated osh script for possible errors.
  2. Remove the constraint on the output link.
  3. Turn trace on using DataStage Administrator.
  4. Add a Reject link to the Transformer stage.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

58) Which one is false statement about the Parallel Transformer stage?

  1. The Transformer allows you to copy columns.
  2. The Transformer allows you to do lookups.
  3. The Transformer allows you to apply transforms using routines.
  4. The Transformer allows you to do data type conversions.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

59) How does Hash Partition in a join stage affects the performance?

  1. Better performance
  2. Lower performance
  3. No Change
  4. Cant Say

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

60) The default partitioning method of a derived operator is

  1. Any
  2. Hash
  3. Round Robin
  4. Random

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

61) Which one is not a keyless partitioning method?

  1. Entire
  2. Modulus
  3. Round Robin
  4. Random

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

62) Which two partitioning methods are keyless?

  1. Round Robin
  2. Entire
  3. Hash
  4. Both A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

63) Which one of the below is a passive stage?

  1. Peek stage
  2. Aggregator stage
  3. Sort stage
  4. Transformer stage

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

64) By default where can you output data using Peek stage?

  1. job log in director
  2. link properties of peek
  3. stage properties of peek
  4. none

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

65) Pivot stage in DataStage before 8.5 supports

  1. Only horizontal pivoting i.e. columns into row
  2. Only vertical pivoting i.e. rows into columns
  3. Both A & B
  4. None of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

66) Players process are                                    A.The actual processes associated with Stages                                                      B.Send stderr to SL                             C.Establish connections to other players for data flo

  1. A,B and C
  2. All
  3. D only
  4. A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

67) Protected Project can be accessible only by user who has

  1. Super Operator role
  2. Production Manager role
  3. Super Operator & Production Manager Roles
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

68) What Happens if RCP (Runtime column propagation) is disabled?

  1. Datastage jobs cannot be run
  2. OSH has to perform Import and export every time when the job runs and thus processing time of job is increased.
  3. The metadata of those stage whose output connects to the shared container input, will not be stored
  4. No impact on Datastage jobs and the metadata will be propagated at run time

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

69) When RCP is Disabled                          A.DataStage Designer will enforce Stage Input Column to Output Column mappings.             B.At job compile time modify operators are inserted on output links in the generated osh C.Modify operators can add

  1. A only
  2. A and B
  3. None
  4. All

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

70) When RCP is Enabled                            A.DataStage Designer will not enforce mapping rules.                                                                      B.No Modify operator inserted at compile time. C.Danger of runtime error if column nam

  1. A and B
  2. B and C
  3. All
  4. D only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

71) Which should specified to manage Runtime Column Propagation?

  1. enabled in DataStage Administrator and at the stage level
  2. attached to a table definition in DataStage Manager
  3. enabled only at the stage level
  4. enabled with environmental parameters set at runtime

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

72) One of the below object don’t be a part of DataStage Repository

  1. Jobs
  2. Table Definitions
  3. Shared containers
  4. Local containers

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

73) Section Leader process are                     A.Forks Players processes (one/Stage) B.Establish connections to other players for data flow                                          C.Manages up/down communication.     D.Clean up upon completion.

  1. A and C are correct
  2. A and B are correct
  3. C and D are correct
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

74) Sequencer job does not consist?

  1. Activity Stage
  2. Command Stage
  3. Routing Stage
  4. Non of them

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

75) Which one of the below would not be necessary to build a Job Sequence that: picks up data from a file that will arrive in an directory overnight, launches a job once the file has arrived, sends an email to the administrator upon successful completion of t

  1. Notification Activity
  2. Wait For File Activity
  3. Job Activity
  4. Sequencer

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

76) Difference between Hashfile and Sequential File in server job?

  1. Hash file stores the data based on hash algorithm and on a key value. A sequential file is just a file with no key column.
  2. Hash file can be used as a reference for look up. Sequential file cannot
  3. searching a record is faster in hash file as comparedf to sequential file.
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

77) Sequential File Stage                              A.Normally will execute in sequential mode B.Can execute in parallel if reading multiple files (file pattern option)                                            C.Can use multiple readers within a node on

  1. A
  2. B
  3. A and B
  4. All

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

78) Which “Reject Mode” option in the Sequential File stage will write records to a reject link?

  1. Output
  2. Fail
  3. Drop
  4. Continue

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

79) How I can convert Server Jobs into Parallel Jobs?

  1. You can convert your server job into a server shared container. The server shared container can also be used in parallel jobs as shared container.
  2. Using IPC Stage, by keeping this stage in between two passive stages
  3. Using LINK PARTITIONER AND LINK COLLECTOR
  4. Not possible

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

80) How can improve the performance of the server jobs?

  1. By enable inter process row buffering through the administrator.
  2. By adding IPC stage between two passive stages
  3. A only
  4. Both A and B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

81) Identify the usages of INPROCESS , INTERPROCESS row buffers from the following

  1. In Process – Connected between active stages. Improves performance of the jobs by turning of and on job recompilation.
  2. Inter Process – Used when running on SMP parallel system. Enables the job to run using a separate process for each active stage, which
  3. In Process – Connected between active stages. Improves performance of the jobs by turning in-process row bufferring during execution of the job
  4. Inter Process – Used when running on SMP parallel system. Enables the job to run using the same process for e
  5. In Process – Connected between active stages. Improves performance of the jobs by turning in-process row bufferring on and recompiling the job.
  6. Inter Process – Used when running on SMP parallel system. Enables the job to run using a separate process f
  7. In Process – Connected between active stages. Improves performance of the jobs by turning of and on job recompilation.
  8. Inter Process – Used when running on MPP system. Enables the job to run using a separate process for each active stage, which is run s

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

82) True or False?                                                A.Server jobs are compiled and run on DataStage Server                                        B.Parallel jobs are compiled and run on a DataStage Unix Server and can be run in parallel on SMP M

  1. Both are False
  2. A True and B False
  3. Both are True
  4. B True and A False.

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

83) In MPP/ Cluster systems                                          A. Each node is a uniprocessor or SMP.               B. Its having own hardware resources.                C. Its sharing hardware resources across all nodes

  1. B and C
  2. D Only
  3. A,B and D
  4. B only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

84) if stable sort is set to true it will allow the duplicate records to output links?

  1. True
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

85) Surrogate Key stages properties are          A.Value Of the key is 16-bit, 32-bit, or 64-bit integer.                                                         B.starting number is 0 by default.                                   C.starting number is 1 by de

  1. A,B and D are correct.
  2. D Only
  3. A and B Only
  4. A Only

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

86) Which Statements describes how to add functionality to the Transformer stage?

  1. Edit the C++ code generated by the Transformer Stage
  2. Create a new parallel routine in the routines category that specifies name,type,path and return type of an external program
  3. Create a new server routines in the routines category that specifics the name and category of the function written in datastage Basic
  4. Create a new parallel routine in the routines category that specifics the name,path,type and return type of a function written and compliled in C++

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

87) One of the below execution order is true in Transformer Stage

  1. Stage Variable > Function > Routine
  2. Stage Variable > Constraint > Derivation
  3. . Constraint > Stage Variable > Equation
  4. Derivation > Function > Stage Variable

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

88) Which one of the below reason would cause of using a Transformer stage instead of a Copy stage?

  1. Drop a column.
  2. Send the input data to multiple output streams.
  3. Select certain output rows based on a condition.
  4. All of the above

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

89) In CDC stage the ‘Delete’ option would recognise those

  1. records that are dropped in After Link
  2. records that are dropped in before Link
  3. records that are dropped in both the link
  4. A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

90) Which containers can be saved independenly

  1. Shared Containers
  2. Local Containers
  3. Globe containers
  4. direct containers

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

91) During run time what is the default warnings after which a job would abort?

  1. 100
  2. 150
  3. 50
  4. 200

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

92) A job is built with multiple active stages interconnected. To get the warnings that’s generated correctly at the active stage which environmental variable has to be used?

  1. APT_CONFIG_FILE
  2. APT_DISABLE_COMBINATION
  3. APT_STARTUP_SCRIPT
  4. APT_THIN_SCORE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

93) Which environment variable is used to override the pad character of 0x0 (ASCII null), used by default when InfoSphere® DataStage® extends, or pads, a string field to a fixed length

  1. APT_STRING_PADCHAR
  2. APT_DELIMITED_READ_SIZE
  3. APT_MAX_DELIMITED_READ_SIZE
  4. APT_IMPORT_PATTERN_USES_CAT

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

94) Exporting the job in ISX feature helps to

  1. Export jobs within a project
  2. Export jobs across projects within a server
  3. A & B
  4. Exports job even with executables if needed

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A, B & D[/bg_collapse]

95) In a Join stage the key columns have a different naming convention. So

  1. Use transformer stage before Join stage to rename the key columns to match both the links
  2. Use Copy stage before the Join stage to rename the Key columns to match
  3. Need not use any stages but directly connect the link to Join Stage
  4. A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

96) The job has stage variables defined in the transformer. The stage variables are defined in such a way that they are dependent on each other

  1. The order of the stage variables defined impacts the output
  2. The order of the stage variables defined does not have any impact on the output
  3. Order of Execution within the stage variables are not mandate
  4. None

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]

97) The Sort stage and Link sort stage does the functionality of the sorting. So

  1. Both of the types of stage do only sorting and no additional functionality
  2. Duplicates can be removed in link sort
  3. Duplicates can be removed in Sort stage
  4. Key change column is available in link sort

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

98) Complex flat files can

  1. Read flat files
  2. Read compressed VSAM files
  3. can have reject link
  4. ALL

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

99) In the lookup stage the warning “Ignoring duplicate entry at table record” indicates

  1. Duplicate in primary link
  2. duplicates in the reference link
  3. Duplicates at both the link
  4. A & B

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]

100) Which one streamlines collaboration between business analysts, data modelers, and developers by capturing and defining business requirements in a common, familiar format and then transforming that business logic directly into DataStage ETL jobs

  1. Designer
  2. Glossary
  3. FastTrack
  4. Director

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]

101) For Joining data between two different links with a logic of left outer and with the rejects

  1. use Lookup stage
  2. Use Join stage
  3. Use Merge stage
  4. A &C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

102) For getting data from a reference link that’s huge in size

  1. use Lookup stage
  2. Use Join stage
  3. Use Merge stage
  4. B&C

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]

103) To import the table definition use the following options

  1. ODBC Table definition
  2. Plug in Metadata definition
  3. Orchestrate Schema Definition
  4. All

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]



Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz