The target Sequential File stage has been set to write to two different

The target sequential file stage has been set to

This preview shows page 2 - 4 out of 6 pages.

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
Image of page 2
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?
Image of page 3
Image of page 4

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

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture