In this Approach first of all we are loading the data marts after that we are loading the data ware house. This approach is also called dimensional modeling approach.
In this approach, we are extracting the data from difference
data source and loading the data into the staging table using ETL and after
that we are loading these data to the Data marts. Once data loaded into the
data Marts we are loading the data into the data ware house using ETL tool.
