August 19th, 2013
So far we have discussed Data Design, Extraction and Transformation in the data migration series. Data Loading is the fourth phase, in which the transformed data is loaded into your new repository or database, and also the final step in the ETL process (Extract, Transform, Load). The ETL tool chosen by the migration team to perform the load will ensure consistency as the data is loaded. Any indexing is typically disabled until all the data is imported, then re-enabled once complete.
As with any major cutover project, it’s important to have a contingency plan, in case any part of the process fails. The migration team will have planned for any issues in advance that could happen during data loading, and will be prepared to take steps necessary to back out and restart the process if necessary.
Once the data is loaded, the next step is Verification, to ensure accuracy and consistency. Stay tuned for the next phase!
Wikipedia - The Free Encyclopedia, "Extract, transform, load." Accessed July 8, 2013. http://en.wikipedia.org/wiki/Extract,_transform,_load.
Javlin Data Solutions, "Data Integration Information - ETL (Extract-Transform-Load)." Accessed July 8, 2013. http://www.dataintegration.info/etl.
AltaFlux understands what you and your organization need to excel, and can deliver rapid innovation to unleash your full workforce potential. Together, we can empower your business by streamlining, transforming, and optimizing your key HCM and talent processes with industry-leading SAP SuccessFactors technology—enabling you to adapt at the speed of change.
AltaFlux Corporation is a global HCM cloud consulting partner based in Troy, Michigan. We empower organizations by streamlining, transforming, and optimizing key human capital management (HCM) processes with industry-leading HCM cloud solutions like SAP SuccessFactors, Benefitfocus, WorkForce Software and Dell Boomi.