Properties that can be configured for the Data Type Definition Preparation
Component.
Syntax Use this component to change the name, data type, and date format of the source column.
Defining the data type helps you to prepare data to make it suitable for further
analysis.
For example:
- If the name of the column in the data source is "des", it may not be clear
during analysis. You can change the name of the column to "Designation" in
the analysis, so that the end users can easily understand it.
- If the date is stored in the mmddyy (120201, without any date separator)
format, it may be considered as an integer value by the system. Using the
Data Type Definition component, you can change the date format to any valid
format such as mm/dd/yyyy, or dd/mm/yyyy, and so on.
To change the name, data type, and the date format of the source column, perform the
following steps:
- Add the data type definition component into the analysis.
- From the component's contextual menu, choose Configure
Properties.
- To change the column name, enter an alias name for the required source
column.
- To change the data type of the column, select the required data type for the
source column.
- Choose Done.