1.What is difference between the fact table and the aggregate table in the data mart.

Fact table are also measures and mostly aggregates. Aggregate tables stand by its name.

2. Why aggregate tables are not always connected?

Please explain to me