Interview Question - Optimization Context

Q:what is the Optimization Context used for?
Ans: ODI uses the Optimization Context to validate your Mapping at design time.
This means it will validate your filters,functions etc. against the environment setup in your Optimization Context.

How to use Select query inside ODI 12c mapping?

Scenario:

Need to populate employee hierarchy for that technical team provided the SQL. I have to build ODI mapping for that. I decided to use SQL as it is.

Steps:

1.       Drag and Drop Target datastore twice on to the Mapping editor

2.       Select first datastore and change the alias name as “SQ”

3.       Select Second datastore and change the alias name as “TRG”

4.       Go to Physical

5.       Select “SQ” and go to property inspector and expand “Extract Options” à Go to “Custom Template” and in place value provide your SQL

6.       Connect SQ output connector to TRG input connector

7.       Enable auto map

8.       Run the mapping it load the data to Target table