Multiple choice technology

which of the following is efficient in handling flatfile duplicate rows as distinct rows

  1. a. source qualifier transformation alone.

  2. b. sorter and sequence generator.

  3. c.source qualifier and expression transformation

  4. d. sorter transformation alone
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To handle flat file duplicate rows as distinct rows, you need to sort the data first to group duplicates together. Sorter transformation alone is sufficient to organize the data so duplicates can be identified. Other options (source qualifier with sequence generator or expression) don't directly address the duplicate detection problem.

Keep practicing — related questions