What is partitioning? Explain about Round-Robin, Hash partitioning. - ETL
Explain the difference between Power Center and Power mart.
Power Center
- Processes large volumes of data
- ERP sources such as SAP,PeopleSoft,Oracle Apps. can be connected with power center
- Session partition is allowed to improve the performance of an ETL transaction
Power Mart
- Processes low volumes of data
- Does not provide connections to ERP sources
- Does not allow session partitions