PrepAway - Latest Free Exam Questions & Answers

Which of the following will determine the running row n…

Which of the following will determine the running row number within a group?

PrepAway - Latest Free Exam Questions & Answers

A.
Insert an Aggregator stage, hashing on the key column, prior to the Transformer stage

B.
Use a Surrogate Key Generator stage to generate the running row number prior to the Transformer stage

C.
Use a Remove Duplicates stage prior to the Transformer stage based on the key column, with the Duplicate
set to retain = last option

D.
Use a Sort stage prior to the Transformer stage based on the key break column. Then, use the
LastRowinGroup() function to determine the last row in a group


Leave a Reply