I would like to know about multivalues columns in Hasstage and how these should be used.
In hashstage's output section there is property callesd normalize on how should I enable this ?
Thanks
Multivalued columns
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54595
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
For a gentle introduction to multi-valued columns, look here.
Before you can use multi-valued columns, in hashed files or in UV tables, you have to enable them in the metadata. Because none of yours have multi-valued columns defined, the "normalize on" button is disabled.
If you did have multi-valued columns, then using the "normalize on" button has the same effect as using the UNNEST operator in a query, which is discussed in the post to which I referred you earlier.
Before you can use multi-valued columns, in hashed files or in UV tables, you have to enable them in the metadata. Because none of yours have multi-valued columns defined, the "normalize on" button is disabled.
If you did have multi-valued columns, then using the "normalize on" button has the same effect as using the UNNEST operator in a query, which is discussed in the post to which I referred you earlier.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.