What two levels of message handlers are there?
When you run a parallel job, any error messages and warnings are written to the job log and can
be viewed from the Director client. What two levels of message handlers are there? (Choose two.)
Which three of the following are valid options for the dsjob command?
Which three of the following are valid options for the dsjob command? (Choose three.)
What are three valid job status types you can trap for?
You write a job control routine to control a sequence of jobs running as a single unit of work. What
are three valid job status types you can trap for? (Choose three.)
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 SequentialFile
with “Readers per Node” set to “2”. Input 2 (Dataset) comes from a dataset created with 3
partitions. With the Funnel stage, the funnel type is set to “Sequence”. The parallel configuration
file contains three nodes.
How many instances of the Funnel stage run in parallel?
Which two steps will accomplish this?
A job contains a Sort stage that sorts a large volume of data across a cluster of servers. Due to
new requirements, the customer has requested that this sorting be done on a subset of servers
identified in the configuration file to minimize impact on database nodes. The
$APT_CONFIG_FILE shows no sort disk pool for any node. Which two steps will accomplish this?
(Choose two.)
Which technique is the most appropriate?
You have a dataset hash-partitioned and sorted on CustID. You need to create a Sequential File
sorted on CustID from this dataset. Which technique is the most appropriate?
How can a fixed-width single sequential file be read in parallel?
You are running a DataStage job using a 2-node configuration file. How can a fixed-width single
sequential file be read in parallel? (Choose two.)
What is the lowest CPU cost partitioning method?
What is the lowest CPU cost partitioning method?
Choose the action that gives you the best reusability design to effectively implement these common logic areas
In your ETL application design you have found several areas of common processing requirements
in the mapping specifications. These common logic areas found include: code validation lookups
and name formatting. The common logic areas have the same logic, but the jobs using them
would have different column metadata. Choose the action that gives you the best reusability
design to effectively implement these common logic areas in your ETL application?
Which two statements accomplish this requirement?
The purchase history record contains CustID, ProductID, ProductType and TotalAmount. You
need to retain the record of greatest TotalAmount per CustID and ProductType using
RemoveDuplicate stage. Which two statements accomplish this requirement? (Choose two.)