Hi, I have a description column in my data which is mainly a set of key value pairs which will never be searched but will only be retrieved. Due to the nature of the logs, the cardinality of this dimension is going to be nearly equal to the number of rows. Hence I have to disable the dictionary for this dimension and the cube size is increasing multiple times. The length of this column would be around 80-100 characters. This field cannot be split up as it is designed to provided flexibility for collecting measurements. So, is there any provision of specifying a dimension that it will only be retrieved but will never be queried. Does such a thing speed up the cube building process. Please let me know if there is any work around that you guys can think of.
Thank you, Sai Kiriti B.
