When we create a mining model or a mining structure in Microsoft SQL Server Analysis Services, we must define the data types for each of the columns in the mining structure. The data type tells the analysis engine whether the data in the data source is numerical or text, and how the data should be processed. For example, if our source data contains numerical data, we can specify whether the numbers be treated as integers or by using decimal places.

Analysis Services supports the following data types for mining structure columns:

Data Type | Supported Content Types |
---|---|

Text |
Cyclical, Discrete, Discretized, Key Sequence, Ordered, Sequence |

Long |
Continuous, Cyclical, Discrete, Discretized, Key, Key Sequence, Key Time, Ordered, Sequence, Time
Classified |

Boolean |
Cyclical, Discrete, Ordered |

Double |
Continuous, Cyclical, Discrete, Discretized, Key, Key Sequence, Key Time, Ordered, Sequence, Time
Classified |

Date |
Continuous, Cyclical, Discrete, Discretized, Key, Key Sequence, Key Time, Ordered |

You can find details for discrete vs discretized here.