Multiple choice technology

Which of the following statement is/are incorrect? 1) With a normal join, the Integration Service discards all rows of data from the master and detail source that do not match, based on the condition. 2) A master outer join keeps all rows of data from the master source and the matching rows from the detail source. It discards the unmatched rows from the detail source. 3) A detail outer join keeps all rows of data from the detail source and the matching rows from the master source. It discards the unmatched rows from the master source. 4)A full outer join discards all rows of data from both the master and detail sources.

  1. Only 1 is incorrect

  2. All are correct

  3. Except 1, all are incorrect

  4. Only 2 and 3 are incorrect

Reveal answer Fill a bubble to check yourself
C Correct answer