which of the following is unconnected transformation
-
stored procedure
-
Filter
-
sorter
-
joiner
In Informatica, an unconnected transformation is one that is not connected to other transformations in the mapping and is instead called by an expression (like a function). A Stored Procedure transformation can be used in this way. Filter, Sorter, and Joiner must be connected to the data flow.
To answer this question, we need to understand what each transformation does and determine which one is unconnected.
Option A) Stored Procedure - This option is correct because a stored procedure in data integration is an example of an unconnected transformation. An unconnected transformation is not directly connected to the data flow and is usually called from another transformation or mapping.
Option B) Filter - This option is incorrect. A filter transformation is a connected transformation that allows you to filter rows based on specified conditions.
Option C) Sorter - This option is incorrect. A sorter transformation is a connected transformation that sorts data based on specified criteria.
Option D) Joiner - This option is incorrect. A joiner transformation is a connected transformation that combines data from multiple sources based on a specified join condition.
The correct answer is A) Stored Procedure. This option is correct because a stored procedure is an example of an unconnected transformation.