Multiple choice technology

which of the following is false about source qualifier

  1. a. Filter rows when the Integration Service reads source data.

  2. b. Join data originating from the same source database

  3. c. Can specify a target load order based on the Source Qualifier transformations in a mapping

  4. d. Create a custom query to issue a special SELECT statement for the Integration Service to read source data.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Source Qualifier transformations represent source data and can filter rows, join data from the same source, and use custom SQL queries. However, target load order is specified at the TARGET level in session properties, not through Source Qualifier transformations. Source Qualifiers operate on the read side of data flow, while target load order controls write sequence to different targets.

Keep practicing — related questions