How many instances of the Funnel stage run in parallel?
In the exhibit, a Funnel stage has two input links. Input 1 (Seq_File) comes from a Sequential File
stage with “Readers per Node” set to “2”. Input 2 (Dataset) comes from a dataset created with 3
partitions. In the Funnel stage, the funnel type is set to “Sequence”.
The parallel configuration file contains 4 nodes. How many instances of the Funnel stage run in
parallel?
What could the original developer have done to make this task easier for maintenance purposes?
You are assigned to correct a job from another developer. The job contains 20 stages sourcing
data from two Data Sets and many sequential files. The annotation in the job indicates who wrote
the job and when, not the objective of the job. All link and stage names use the default names.
One of the output columns has an incorrect value which should have been obtained using a
lookup. What could the original developer have done to make this task easier for maintenance
purposes?
Which two properties must be selected to ensure that Job1 is run each time, even after a failure?
Your job sequence must be restartable. It runs Job1, Job2, and Job3 serially. It has been compiled
with “Add checkpoints so sequence is restartable”. Job1 must execute every run even after a
failure. Which two properties must be selected to ensure that Job1 is run each time, even after a
failure? (Choose two.)
Which two statements are true regarding this change to the parallel shared container?
You have a parallel shared container that is used by other parallel jobs within your project. Part of
the logic in this shared container has been changed. Which two statements are true regarding this
change to the parallel shared container? (Choose two.)
Which two actions are available when editing a message handler?
Which two actions are available when editing a message handler? (Choose two.)
which design change would improve the performance of this job?
The given job processes large volumes of data using default partitioning, with sort/partition
insertion enabled. Both source Data Sets are partitioned and sorted on the merge key. Assuming
that the business logic allows all of the following actions, which design change would improve the
performance of this job?
What is the result of running the following command: dsjob -report DSProject ProcData
What is the result of running the following command: dsjob -report DSProject ProcData
Which two roles are required to allow a user to edit DataStage jobs?
You are setting up user roles on Information Server Web console. Which two roles are required to
allow a user to edit DataStage jobs? (Select two)
What are two valid ways to do this?
You would like to pass values into parameters that will be used in a variety of downstream activity
stages within a job sequence. What are two valid ways to do this? (Choose two.)
Which two job design configuration actions would you consider to effectively use RCP?
Your job is using the DB2 Enterprise stage as a target. In this job you are inserting data into a
single existing table on a remote database. You are using Run-Time Column Propagation (RCP)
on all of the links.
Which two job design configuration actions would you consider to effectively use RCP? (Select
two)