Biztalk Bam Interview Question:

Tell us what is the dfference between Real Time Aggregation and Scheduled Aggregations used in BAM?

Submitted by: Muhammad

The storage of RTA is a SQL table and the aggregation is updated and maintained by SQL trigger. The event importing and aggregation update are completed in the same transaction, therefore its data latency is negligible and almost real-time. The scheduled aggregation is saved in Olap cubes which need to be processed periodically by the cubing DTS package
Submitted by: Muhammad