The DART data transformation process will apply a series of "rules" or functions to the extracted data from the source to derive the data to be loaded to the end target and technical specification of the end target may be required:

• Selecting only certain columns to load (or selecting null columns not to load)
• Translating coded values (e.g., if the source system stores 1 for male and 2 for female, but the destination stores M for male and F for female)
• Encoding free-form values (e.g., mapping "Male" and "1" and "Mr" into M)
• Deriving a new calculated value (e.g., sale_amount = qty * unit_price)
• Joining together data from multiple sources (e.g., lookup, merge, etc.)
• Summarizing multiple rows of data (e.g., total sales for each store, and for each region)
• Splitting a column into multiple columns (e.g., putting a comma-separated list specified as a string in one column as individual values in different columns)

Back to Data Quality Management