Which two properties can be set to read a fixed width sequential file in parallel? (Choose two.)

• A. Set the "Number of Readers Per Node" optional property to a value greater than 1.
• B. Set the "Read from Multiple Nodes" optional property to a value greater than 1.
• C. Set Read Method to "File Pattern".
• D. Set the Execution mode to "Parallel".

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?

• A. Insert Sort stage before the final Sequential File stage and use Round Robin collector for the Sequential File stage input link.
• B. Insert Sort stage before the final Sequential File stage and use Ordered collector for the Sequential File stage input link.
• C. Use SortMerge collector for the Sequential File input link.
• D. Use Copy stage.

Which condition is required to use the LastRowInGroup() function to determine a key break on a field?

• A. The LastRowInGroup() function requires the data to be grouped by the key field, but the data does not have to be sorted.
• B. The input data has to be sorted by the key field, but it is not required that DataStage be able to detect this. For example, the input data might be sorted before it is input to the job. (However, the job will abort at runtime if the data isn't sorted.)
• C. The LastRowInGroup() function does not require the data to be either sorted or grouped by the key field. If necessary the LastRowInGroup() function will perform a sort.
• D. The input data has to be sorted by the key field and DataStage must be able to detect that the data is sorted, for example, by the presence of a Sort stage.

Which Oracle Enterprise stage read property can be set using -dboptions to tune job performance?

• A. transactsize
• B. memsize
• C. partitionsize
• D. arraysize