Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Data Load from PCMCS to EPBCS using DM

edited Dec 19, 2019 2:59PM in Profitability and Cost Management 3 comments

Summary

Extraction of data from PCMCS and loading it into EPBCS is taking vast amount of time

Content

We want to transfer allocated data from PCMCS to EPBCS. These are the two methods that we followed-

1. Using Direct Integration in Data Management by breaking Data into smaller segments.

This is an approach we had to take because our loads exceeded the limit of 5 million records that PCMCS is capable of handling. But when loaded this way, the segments that are not exceeding the limit, take about 50-60 mins for data transfer for one month.

To summarize, for one segment, the extraction took about 18 mins, import took 13 mins, transformation and staging balance to export took 22 mins (the longest) and then export was done quickly in a minute. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!