Incremental loading means loading the ongoing changes in the OLTP.<br><br>Aggregate table contains the [measure] values ,aggregated /grouped/summed up to some level of hirarchy.<br>
Batch Processing means executing more than one session in single run at the same time. we can execute these session in 2 ways : <br>linear: exececuting one after another<br>parralel: executing more than one session at at time
Incremental loading means loading the data without any outage to the users who are using the database for reporting purpose.<br>Aggregate tables you can check in Net , it nothing but the aggregate of certain value from the fact tables in Star schema.<br><br>Batch processing is explained by |Srinivas Rao.