Delay in one region stream affected the other region streams and due to a feed from EPM to FGL system, there was additional impact as well.
There are Daily and Monthly ETL jobs that are scheduled to run through Control-M and the jobs run 24/7 due to different regions of business by the client (NA, APAC and EMEA).Īfter we upgraded our Datastage environment from 7.5 to 8.5 the performance of the jobs reduced by at least 30% and this had an high impact on the deliverables. Datastage is used in loading every layer of the warehouse (Stage, Enriched and Multi-Dimension layers). We have Peoplesoft EPM 8.9 Warehouse setup and Datastage is the ETL tool that is used to load the data into different layers of warehouse.
We have recently upgraded from Datastage 7.5 to IBM Infosphere Information server Datastage 8.5.
0 kommentar(er)
