You need to read data from three oracle tables that store sales data from three regions to load into a single oracle table. These three tables are having the same table definitions and the only difference is that each table contains data for a particular region. Which of the following will do the required task?

technology platforms and products

  1. Create a task with single oracle enterprise stage that executes a custom SQL statement with FETCH ALL, that outputs to an Oracle enterprise stage.

  2. Create a job with three Oracle Enterprise stages to read from the tables and output to a collector stage which in turn outputs the data to an Oracle Enterprise stage.

  3. Create a job with a single Oracle Enterprise stage that executes a custom SQL statement with UNION ALL that outputs the data to an oracle enterprise stage.

  4. Create a job with three Oracle Enterprise stages to read from the tables and output to a Funnel stage which in turn outputs the data to an oracle enterprise stage.

Show answer
Correct Option: C,D

AI Explanation

To answer this question, let's go through each option to understand why it is correct or incorrect:

Option A) Create a task with a single Oracle Enterprise stage that executes a custom SQL statement with FETCH ALL, that outputs to an Oracle Enterprise stage.

This option is incorrect because using FETCH ALL in a custom SQL statement will only fetch all rows from a single table, not from multiple tables.

Option B) Create a job with three Oracle Enterprise stages to read from the tables and output to a collector stage which in turn outputs the data to an Oracle Enterprise stage.

This option is incorrect because using a collector stage will not combine the data from the three tables into a single table. It will only collect the data from each table separately.

Option C) Create a job with a single Oracle Enterprise stage that executes a custom SQL statement with UNION ALL that outputs the data to an Oracle Enterprise stage.

This option is correct because using UNION ALL in a custom SQL statement will combine the data from the three tables into a single result set. The Oracle Enterprise stage can then output this combined data to a single table.

Option D) Create a job with three Oracle Enterprise stages to read from the tables and output to a Funnel stage which in turn outputs the data to an Oracle Enterprise stage.

This option is correct because using a Funnel stage will combine the data from the three Oracle Enterprise stages into a single stream. The combined data can then be output to an Oracle Enterprise stage to load into a single table.

The correct answer is C, D. These options will allow you to read data from the three Oracle tables and load it into a single Oracle table. Option C uses UNION ALL in a custom SQL statement, while Option D uses a Funnel stage to combine the data.

Find more quizzes: