Oracle
1Z0-448 · Question #66
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.)
The correct answer is C. In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options. (https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize)
Developing Integration Mappings
Question
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.)
Options
- ADuplicate the Integration Knowledge Module, add an option CUSTOM_TEMPLATE, and set it
- BDuplicate the Check Knowledge Module, add an option CUSTOM_TEMPLATE, and set it within
- CIn the Physical tab of a Mapping, click one of the source data stores, select the Extract Options,
- DDuplicate the Loading Knowledge module, add an option CUSTOM_TEMPLATE, and set it within
How the community answered
(28 responses)- A14% (4)
- B7% (2)
- C75% (21)
- D4% (1)
Explanation
(https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize)
Topics
#custom SQL#Extract Options#physical tab#source override
Community Discussion
No community discussion yet for this question.