The Import from Source feature enables the Oracle Data Integrator to import the data from the source system, performs the necessary transformation, such as import, map and validate the data. The Import from Source features also allows you to import the source either online (immediate processing) or offline (runs in background).
Select this feature only if:
You are running a data load rule for the first time.
Your data in the source system changed. For example, if you reviewed the data in the staging table after the export, and it was necessary to modify data in the source system.
In many cases, source system data may not change after you import the data from the source the first time. Therefore, it is not necessary to keep importing the data if it has not changed.
To submit the data load rule:
From the table action bar, select the Data Rule drop down, and choose the data load rule.
The Execution Mode Option screen is displayed.
From the Execution Mode drop down, select the mode of importing the source.
Execution modes include:
online—ODI processes the data in sync mode (immediate processing).
offline—ODI processes the data in async mode (runs in background).
Click on the Import or Export hyperlink in the status region to navigate to the Process Detail page to monitor the ODI job progress.
After you run a data rule, check the status of the import on the POV bar.
.