Multivalued columns

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
Gnaneswar kacham
Participant
Posts: 1
Joined: Thu May 13, 2004 12:25 pm

Multivalued columns

Post by Gnaneswar kacham »

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
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply