DW Handbook

This page shows the name of the stage, its description and how it was created (references)

Name Cleaning
Explanation Perform cleansing tasks on the complete dataset, certain records or certain fields
Task(s)
Cleaning:Operations related to removing empty records, dealing with missing values, duplicate and outlier identification and removal
Formatting:Changing of a field format from one type to another (e.g., String to number, int to double)
Formatting:Changing of a field format from one type to another (e.g., String to number, int to double)
Used In pm1 , pm2 , pm3 , pm4 , ps1 , ps2 , ps3
DW Constructs Impute Values , Remove Null , Column Convert , Filter Rows , Remove Column , Remove Duplicates

Back