Multiple choice technology

Which two stages allow reject links? (Choose two.)

  1. Join stage

  2. Merge stage

  3. Funnel stage

  4. Lookup stage

Reveal answer Fill a bubble to check yourself
B,D Correct answer
Explanation

In IBM DataStage, the Merge and Lookup stages allow reject links to capture records that don't meet match criteria. Join stage doesn't support reject links, and Funnel stage combines streams without rejection logic.

AI explanation

To answer this question, we need to understand the concept of reject links in the context of data integration or data processing stages.

Reject links are used to capture and handle data records that do not meet certain conditions or criteria during the processing stages. These links allow you to route rejected records to separate paths for further analysis or handling.

Let's go through each option to determine which stages allow reject links:

Option A) Join stage - Join stages are used to combine data from multiple sources based on a common key. However, join stages do not typically allow reject links. Therefore, this option is incorrect.

Option B) Merge stage - Merge stages are used to combine data from multiple inputs into a single output. The merge stage allows for the creation of reject links, which can be used to handle records that could not be merged successfully. Therefore, this option is correct.

Option C) Funnel stage - Funnel stages are used to consolidate data from multiple inputs into a single output. Funnel stages do not typically allow reject links. Therefore, this option is incorrect.

Option D) Lookup stage - Lookup stages are used to retrieve additional information from a reference dataset based on matching criteria. The lookup stage allows for the creation of reject links, which can be used to handle records that could not be matched successfully. Therefore, this option is correct.

In summary, the two stages that allow reject links are:

B) Merge stage D) Lookup stage

These stages enable you to capture and handle data records that do not meet specific conditions during the data integration or processing.