which of the following transformation is not using to connect more than one table
-
joiner
-
source qualifier
-
lookup
-
sorter
The Sorter transformation sorts data within a single pipeline and doesn't connect multiple tables. Joiner explicitly joins two heterogeneous sources, Source Qualifier can join tables from the same source database, and Lookup can reference another table - all three connect multiple tables, but Sorter only operates on one stream.
To answer this question, you need to understand the different transformations used in connecting more than one table in a database or data integration process.
Let's go through each option to understand why it is correct or incorrect:
Option A) joiner - This option is correct because the joiner transformation is used to combine data from multiple tables based on a common key column.
Option B) source qualifier - This option is correct because the source qualifier transformation is used to define the properties of a relational source table, including the SQL query to retrieve data from the table.
Option C) lookup - This option is correct because the lookup transformation is used to retrieve data from a reference table based on a matching key column.
Option D) sorter - This option is incorrect because the sorter transformation is not used to connect more than one table. It is used to sort data based on one or more key columns.
The correct answer is D) sorter. This option is incorrect because the sorter transformation is not used to connect more than one table.
Therefore, the correct answer is D) sorter.