Specifying the Data Type and Content Type (Basic Data Mining Tutorial)

 

Applies To: SQL Server 2016 Preview

Now that you have selected which columns to use for building your structure and training your models, make any necessary changes to the default data and content types that are set by the wizard.

Review and modify content type and data type for each column

  1. On the Specify Columns' Content and Data Type page, click Detect to run an algorithm that determines the default data and content types for each column.

  2. Review the entries in the Content Type and Data Type columns and change them if necessary, to make sure that the settings are the same as those listed in the following table.

    Typically, the wizard will detect numbers and assign an appropriate numeric data type, but there are many scenarios where you might want to handle a number as text instead. For example, the GeographyKey should be handled as text, because it would be inappropriate to perform mathematical operations on this identifier.

    ColumnContent TypeData Type
    Address Line1DiscreteText
    Address Line2DiscreteText
    AgeContinuousLong
    Bike BuyerDiscreteLong
    Commute DistanceDiscreteText
    CustomerKeyKeyLong
    DateLastPurchaseContinuousDate
    Email AddressDiscreteText
    English EducationDiscreteText
    English OccupationDiscreteText
    FirstNameDiscreteText
    GenderDiscreteText
    Geography KeyDiscreteText
    House Owner FlagDiscreteText
    Last NameDiscreteText
    Marital StatusDiscreteText
    Number Cars OwnedDiscreteLong
    Number Children At HomeDiscreteLong
    RegionDiscreteText
    Total ChildrenDiscreteLong
    Yearly IncomeContinuousDouble
  3. Click Next.

Specifying a Testing Data Set for the Structure (Basic Data Mining Tutorial)

Creating a Targeted Mailing Mining Model Structure (Basic Data Mining Tutorial)

Content Types (Data Mining)
Data Types (Data Mining)

Show: