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 when:
You are running a data load rule for the first time.
Your data in the source system changed. For example, when 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 when it has not changed.
To import source data:
From the Workflow tab, and then under Data Load, select Data Load Workbench.
Optional: When you import a source file, FDMEE uses the current POV to determine location, category, and period.
To import another source file, you must change the POV. For information on changing the POV, see Using the POV Bar.
In Execution Mode drop-down, select the mode of importing the source.
online—ODI processes the data in sync mode (immediate processing).
offline—ODI processes the data in async mode (runs in background).
Click
to navigate to the Process Detail page to monitor the ODI job progress.
The color of the Import fish changes to orange.