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
Post your comment