ODS keeps the transactional data from where direct reporting is possible. The data in ODS can be partly denormalized.Staging area is the exact replica of the transactional database which acts as a source for datawarehouse processing.
ODS, Operational Data Store is majorly different from Staging in the below
aspects:
- Existing Records in the System can get updated based on necessary instructions
& design.
- It can be use...