PrepAway - Latest Free Exam Questions & Answers

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

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

PrepAway - Latest Free Exam Questions & Answers

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 and DataStage must be able to detect that the
data is sorted,for example,by the presence of a Sort stage.

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,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.)

Explanation:


Leave a Reply