Oracle^® Business Intelligence Disconnected Analytics Administration and Configuration Guide > Synchronizing Applications in Oracle BI Disconnected Analytics > Step 5: Setting Up for Incremental Synchronization >

About Incremental Data Sets

The primary difference between incremental synchronization and a full download is the way it handles data integrity and data set validity. In a typical environment, each Oracle BI Disconnected Analytics application contains at least one full data set and multiple incremental data sets. A full data set is a data set that does not depend on any other data set. Full data sets create tables and then load the data for the first time. For incremental data sets, the Oracle BI Disconnected Analytics Application Manager appends data using the SQL scripts specified in the incremental data set. You must set up the SQL scripts correctly for this to work.

Incremental data sets are defined in the same way as full data sets, by defining a data set in a configuration file. While an application can have multiple data sets, each data set has its own configuration file. Only the "incremental" attribute differentiates incremental data sets from a full data set.

Different users may have downloaded data on different dates, so their data may differ depending on the following factors:

• Last update date. The last date that the user synchronized.
• Today's date. The date on the user's disconnected machine.

The Oracle BI Disconnected Analytics Application Manager does not automatically manage data integrity when the Oracle BI Disconnected Analytics Application Manager loads data from multiple data sets into the tables. You must ensure that the data that is loaded does not create duplicates.