Data movement revolves around the E (Extract), T (Transform), and L (Load) in ETL. In a typical implementation, you will deploy the P6 EPPM Database and data warehouse (ODS/STAR) on separate physical servers. So, you must maximize the bandwidth and minimize latency between servers. Ideally, the servers reside in the same data center with gigabit ethernet connecting the servers. (Oracle Primavera performance tests are performed with servers in a central data center with gigabit connections.) You should verify throughput of server communication by performing basic file copy or FTP operations between the servers.
The data movement processes is based on the standard SQL, either with INSERT-SELECT or CREATE TABLE AS (CTAS) syntax using an Oracle database link. While the Oracle RDBMS is efficient at moving data through the link, the overall performance depends on the physical network connection.
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014