Run the ETLs

Previous TopicNext TopicContents

To setup the ETL:

  1. Rename the folders for the first data source back to the original name.
  2. Run the ETL from that folder by running staretl.bat “-s1” or the staretl.sh “-s1”.
  3. Determine how long each ETL process takes. If the first ETL takes 4 hours and the second takes 6 hours, you need to set the jobs to run at separate times and allow extra time if one ETL run goes longer than usual. You should monitor this as ETL runtimes and Star history fact tables can grow as data grows in P6.
  4. Run the ETL for the second data source as staretl.bat “-s2” or the staretl.sh “-s2”.

Tips



Legal Notices
Copyright © 1999, 2014, Oracle and/or its affiliates. All rights reserved.

Last Published Friday, January 31, 2014