You want to override the code generated by ODI and provide a custom SQL statement as the source of a Mapping. How must you proceed? (Choose the best
answer.)
A.
Duplicate the Integration Knowledge Module, add an option CUSTOM_TEMPLATE, and set it within the Mapping.
B.
Duplicate the Check Knowledge Module, add an option CUSTOM_TEMPLATE, and set it within the Mapping.
C.
In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, and enter the SQL statement in the CUSTOM_TEMPLATE field.
D.
Duplicate the Loading Knowledge module, add an option CUSTOM_TEMPLATE, and set it within the Mapping.
Explanation:
(https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize)