Creating a load process
BIRT Analytics Loader supports creating data load transactions, setting load process options, and running a set of transactions as a process. To create a load process, first create the transactions that load data. Then, set options that run the load process.
About transactions
A transaction includes all settings and data mappings required to load data into a single table. A load process executes multiple transactions. You must save any change that you make to a load process before executing the process. To save any change to a process, choose Save on the menu bar.
The Options panel in the Data tab provides options for defining a process and tools for creating transactions, as shown in the example in Figure 3‑23.
Figure 3‑23 Defining data
Setting load process options
Select the options that define your load process in the Options panel, shown in Figure 3‑24. The settings that you save for each process execute when the process runs, as part of a data load project.
Figure 3‑24 Reviewing loading options
Select or specify values for each option to execute the following process tasks:
*Load
Select Load to execute all load transactions when a project runs.
*Transform
Select Transform to execute all transformation scripts when a project runs. Define transformation rules using the Transformation tab.
*Post loading
Select Post loading to automatically synchronize the database and remove the cache.
*Notify
Type a value that sets a trigger to write a log message each time the set number of records loads.
*Sample
Specify the records loaded for each table.
Ignoring items during the load process
Ignore items such as tables and instructions during the loading process using the Data tab and the Transform tab. Clicking on the “check” symbol in the Active column in the Data tab, as shown in Figure 3‑24 to ignore the element during the loading process (toggling them on and off). The contents of ignored item rows appear in italics.