1 Reply Latest reply: Jan 13, 2012 9:46 AM by Mark Kelly-Oracle RSS

    Problem reading the nested column

    900128
      Hi,

      could you share your experience to use DM_NESTED_CATEGORICAL & DM_NESTED_NUMERICAL variable types? I create a view with DM_NESTED_CATEGORICAL variable type but I don't see this variable listed in target, case id in SVM classification model. I create data view based on below query.

      select customer_key,country_name,industry,segment,
      CAST(collect(DM_NESTED_CATEGORICAL(product_code,USER_TYPE)) AS DM_NESTED_CATEGORICALS) CUSTOMER_PRODUCT
      from MY_DM_TABLE
      group by ccustomer_key,country_name,industry,segment
      order by customer_key

      Thank you,
      Bhanu