Initial Load with Cleansing

With this strategy all the data is cleaned completely before importing it into TIBCO MDM.

Although you can acquire clean data quickly using this strategy, you need a reasonable amount of effort to prepare the ETL (extract, transform, and lookup) solution. Typically this is a one-time activity.

To clean the data:

  • Use an extract, transform, load (ETL) tool to transform, lookup, and enhance data as required. Kettle is a free ETL tool that can quickly process a large amount of data.
  • Write this data to a text file and then import it into TIBCO MDM using Database Loader.