Incremental loading a.k.a Delta loading is a widely used method to load data in data warehouses from the respective source systems.
A delta load, by definition, is loading incremental changes to the data after Initial Load is performed. Performing a delta load is equivalent to inserting rows on a fact table and updating the changed data to the existing rows on a fact table.
High volume of Delta Load data is received by IIB/ACE in the form of flat file every time some change happens in the source system. The new changes in the delta values needs to be loaded into DB2 tables (Inserts/updates).
Here the source of input for Delta load is considered to be Flat Files. Multiple Flat Files can be received by IIB on a daily basis.
Sample Minus Query: SELECT EMPID AS EMP_ID, NAME AS EMP_NAME FROM KTF34428.EMPTAB MINUS SELECT A EMPID AS EMP_ID, B AS EMP_NAME FROM KTF34428.DUMMY;
At Royal Cyber we help you manage incremental data load through IBM Integration Bus/App Connect Enterprise (ACE) configurations. For more information about running the Data Load utility, you can write to us at [email protected] or visit www.royalcyber.com.