Building Global Superstore Data Mart using Informatica power center
- What is a data mart?
A data mart is a subset of a data warehouse focused on a particular line of business, department, or subject area. Data marts make specific data available to a defined group of users, which allows those users to quickly access critical insights without wasting time.
extract data from Global_Superstore Table, create star schema then load data after applying the transformation
- Informatica PowerCenter installed and configured
- Access to a database where the data mart and audit table will be created