Interview Questions

Explain the difference between Power Center and Power mart.. - ETL

ETL (extract, transform, and load) Testing Interview Questions


(Continued from previous question...)

6. Explain the difference between Power Center and Power mart.. - 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

(Continued on next question...)

Other Interview Questions