MY FISRT MAPPING IN ODI-TABLE - TABLE MAPPING

 Hi Gurus,

Now you are going to create first mapping in ODI.
Run ODI Studio.
Connect to repository.
Click on Designer
Expand your DEMO project

Right click on interfaces
Click on New interface
Give the name of the interface as "INF_TRG_EMP"
Click on mapping Tab

Now Drag and Drop "EMP" datastore from "SRC_SCOTT" model on to the source pane as shown below.
Also drag and drop the "TRG_EMP" data store from "TRG_SCOTT" model on to the target pane as shown below
Click yes to Automatic mapping

 Click on Flow Tab
Click on Target on the flow to see IKM Target properties
Set "FLOW_CONTROL" option to FALSE
Set "Truncate" option to TRUE
Click on Save

Right click on interface
Click on Execute
Click ok
Click ok

 Click on operator
Expand Date
Expand Today
Double click to open the log of the session
Green mark indicates success of the session
Red-Failed
yellow-Error

 You can see the number of inserts as 14 records

Thanks & Regards
WWW.ODIGURUS.COM