Multiple choice technology

What are all the methods that can be used to identify source bottlenecks for relational sources?

  1. Use a Filter transformation to measure the time it takes to read source data

  2. Use a read test mapping

  3. Use a database query

  4. Use a Sorter transformation to measure the time it takes to read source data
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Identifying relational source bottlenecks requires measuring query/data retrieval performance: Filter transformation with timing, read test mapping (single-source mapping to test speed), or running the source database query directly. A Sorter transformation processes already-read data and doesn't measure source read time.

Keep practicing — related questions