August 14th, 2013
After discussing Data Extraction and Design we now move onto the third piece of the puzzle - Data Transformation, also known as Cleansing. In this phase, the data that was extracted from its original source, is analyzed and “cleansed” for accurate loading into the new destination. Data is checked for integrity and any necessary business rules are applied as the data is processed. Data Quality plays a huge part in this phase. There are six parts to Data Quality:
Other areas to look for when performing a Data Quality check:
Data Transformation is made up of two elements, data mapping and code generation. First, the data is mapped from the source to the destination, which determines any transformation of data which must be done. The code generation piece is an executable piece of software that is run and performs the actual transformation. The timespan for this phase varies with the size and complexity of your data. Once your data is through the Transformation phase, it’s ready for the Load phase.
Wikipedia - The Free Encyclopedia, "Extract, transform, load." Accessed July 8, 2013. http://en.wikipedia.org/wiki/Extract,_transform,_load.
Wikipedia - The Free Encyclopedia, "Data Transformation." Accessed July 8, 2013. http://en.wikipedia.org/wiki/Data_transformation.
Subscribe to the blog to receive updates about:
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.