ODI 11G Expression Interface

Step 1 : Creating Interface

1. Expend project ==>>Right Click on Interface ==>>Click on new ==> Name it as m_ODS_EMPLOYEE
2. 
3. 
4. Click on mapping tab
5. Drag drop employee table from source model
6. Drag drop ods_employee table into target area ==>> click on automatic mapping
7. 
8. Select name column of ODS_EMPLOYEE table
9. in properties window==>> under the implementation
10. type the formula

EMPLOYEE.FIRST_NAME ||' '||EMPLOYEE.LAST_NAME

11. Click on ok
12. Click on flow tab
13. select the target ==>> select IKM as IKM SQL Control APPEND

Note : if IKM drop down is empty then we need to import IKM by right cliking on IKM folder of project ==>>click on import knowledge modules ==>>provide the path as C:\OBIEE_HOME\Oracle_ODI1\oracledi\xml-reference ==>> select IKM SQL CONTROL APPEND ==>>click on ok ==>>click on Close

14. under the IKM selector options ==> select flow_control =False
15. 
16. Click on save
17. Click on run
18. go to operator navigator ==> observe the interface run log
19. 
20. Right click on target table ODS_EMPLOYEE in mapping tab of interface ==>> clcik on view data ==>> notice that all 26 records loaded into target table
21.