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.