<img height="1" width="1" style="display:none" src="https://www.facebook.com/tr?id=1334192293361106&amp;ev=PageView&amp;noscript=1">

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:

  • Completeness – ensuring all data fields are populated that need to be
  • Conformity – checking that the data is in the standard format
  • Consistency – all data is consistent and non-conflicting
  • Accuracy – all data is correct
  • Duplication – data is in the same format
  • Integrity – data retains relationship link information

Other areas to look for when performing a Data Quality check:

  • Duplicate records
  • Irregularities and discrepancies
  • Integrity constraint errors
  • Missing or invalid data
  • Obsolete information

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.

 

Sources:

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.

Learn more about SAP SuccessFactors

Like what you read?

Subscribe to the blog to receive updates about:

  • Growing HR trends and technology
  • SAP SuccessFactors, Benefitfocus, WorkForce Software and Dell Boomi
  • Actionable advice to support your existing HR cloud solutions

AltaFlux Corporation

By AltaFlux Corporation

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.