Data Science & Machine Learning

Hi

In my workflow I'm joining two tables. A sales table and a product table joined on product key.
Here are the following details in my ar analysis:

Transaction id's - slip number id, location sold id
Item Id - product key
Value - class name

The following works fine except that the class name is still too general a description to get meaningful information about the product.


If I do the following:

Transaction id's - slip number id, location sold id
Item Id - product key
Value - style name (which is part of the product table)

the error message I get is:
Item Value style name has too many distinct values. Maximum number of distinct values allowed is 10

How can I increase the maximum number of distinct values (infinite would be great as some of the tables have 100"s of millions of records).

I don't really understand why there has to be this limitation. Can someone explain it to me?

I am using sql developer 3.2.20.09
And Advanced Analytics version 11.2.0.3.0

Thanks in advance!