Which two stages does not allow reject links? (Choose two.)
-
Join stage
-
Merge stage
-
Funnel stage
-
Lookup stage
Join and Funnel stages do not support reject links. Join performs inner/left/right joins without reject capability, and Funnel simply combines inputs. Merge and Lookup stages support reject links for handling unmatched records.
To answer this question, we need to understand the different stages in data integration and transformation processes.
Option A) Join stage - This option is incorrect because the join stage allows reject links. Reject links are used to redirect data rows that do not meet the join condition to a separate path for further processing or analysis.
Option B) Merge stage - This option is incorrect because the merge stage allows reject links. Similar to the join stage, the merge stage also allows redirecting data rows that do not meet the merge condition to a separate path.
Option C) Funnel stage - This option is correct because the funnel stage does not allow reject links. The funnel stage is used to combine data from multiple input sources into a single output stream, and it does not have a separate path for rejected rows.
Option D) Lookup stage - This option is incorrect because the lookup stage allows reject links. The lookup stage is used to retrieve related data from a reference dataset based on matching criteria, and it can have reject links to handle unmatched records.
The correct answer is A and C. The join and funnel stages do not allow reject links.