A job using a three-node configuration file writes to a target Sequential File stage.
The target Sequential File stage has been set to write to two different sequential files.
How many instances of the Sequential File stage will run?
44

A. One instance.
B. Two instances.
C. Three instances.
D. Four instances.
Answer:
B
QUESTION:
128
Each row contains the CustID, ProductID, ProductType and TotalAmount columns.
You want to retain the record with the largest value in the TotalAmount column for
each CustID and ProductType using a RemoveDuplicates stage. How can this be
accomplished?
A. Hash-partition on CustID. Sort on CustID, ProductType and TotalAmount.
B. Hash-partition on TotalAmount. Sort on CustID, ProductType and TotalAmount.
C. Hash-partition on ProductType. Sort on ProductType, CustID and TotalAmount.
D. Hash-partition on CustID, ProductType and TotalAmount. Sort on CustID,
ProductType and TotalAmount.
Answer:
A
QUESTION:
129
What two computer system resources on the DataStage engine are monitored in the
Operations Console? (Choose two.)
A. Disk
B. CPU
C. Memory
D. Scratch disk
E. XMETA database
Answer:
B, C
QUESTION:
130
You want to better understand the tsort operators that are inserted into the job flow at
runtime. Which environment variable can provide this information?


You've reached the end of your free preview.
Want to read all 6 pages?
- Fall '20
- Computer file, ProductType, IBM Information Management Software, Director Job administration