Query as source in 12C
Query as source in 12C:
Today we will discuss on how a query can be used as source in ODI mapping. This time you will see a new option called Extract Options for source data store. Remember a source data store can be the physical data store from the model or it can be a reusable mapping with output signature.
This seems to be more flexible now in terms of mappings. In 11g, for each query you have to create a temporary interface with specific source query, but in 12c you just have to create a generic output signature. Then the query will be mapping specific. Define the query with required fields and skip the unnecessary one. ODI will use its intelligence to select the mapped columns only. Isn’t it a good feature?
You can track the conversation with David in linkedin Oracle Data Integration group.
Okay here you go with screenshots.
Notice I have used a physical data store as source. However you can replace it with a reusable mapping having output signature. You can add as many columns you want into the output signature but make sure the selected fields of your query are present in the signature. You can refer link1 and link2 for reusable map.
You just double click on the value parameter of CUSTOM_TEMPLATE. Copy pest your query and save it. Since the default IKM would have been selected automatically, you can now execute the map.
Notice your query in the above screenshot.
Thanks for reading and ofcourse let me know if you see any issues or flaws.