Data transformation and connectivity tools
 
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
   Events' News
  SIPA Software Roadshow 2014 (Supply chain), Rayong New!
9 Aug 2014
  SIPA Software Roadshow 2014 (Logistics), Chonburi New!
9 Aug 2014
  SIPA Software Roadshow 2014 (Retail), Pattaya New!
19 July 2014
  SIPA Software Roadshow 2014 (Food & Agriculture), Bangkok New!
27 May 2014
   Related links
   Our associations

Go to buythaifirst.com Sipa (Thailand) Go to atsy.or.th Software Park Thailand
Copyright ©2020 Alphametrics.  All rights reserved.