Data Load from PCMCS to EPBCS using DM
SummaryExtraction of data from PCMCS and loading it into EPBCS is taking vast amount of time
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.