Sunday January 21st 2018

Categories

Insider

Archives

Data mart and Historical Data

For example an employee who has been rotated in different departments with different benefits and salary. A data mart allows the company to record the move, and reflects the change in the database.

Without record of employee history or this slowly changing dimension, It would be very hard to performance analyses of employee. Over time, certain dimensions (employees, products, and customers) will change, and your data integration software must be flexible enough to accommodate these changes and produce an accurate view of business performance.Data integration software must be flexible enough to accommodate these changes.