MultiValue Question

[admin]

If you need to normalize on multiple attributes, then
they all must be coordinated attributes. You will
want to define them as part of the same normalization
group, and setup your dictionaries accordingly.

FYI, my recommendation is to setup a DataStage account
on the source server and create localized dictionaries
of clean attribute entries. This way you can define
proper attribute entries with correct formatting, as
well as properly associate multiple groups. One
Universe hash file, when normalized, could turn into
many, I repeat, many normalized target tables because
of rules of normalization. You have to make sure that
your modeler and subject matter experts are aware of
this.

Good luck!
-Ken

--- Edwin Tandiman
wrote:
> Hi,
>
> Does anyone know in DataStage how to extract data
> from a UniVerse file that has attributes with
> multivalues data on them? I know in DS designer as
> I define a UniVerse stage as a source, I can use a
> "Normalize on" option. But this option only allows
> me to normalize on a attribute not multiple
> attributes. Do I need to create a custom function
> or routine in DS and use it in the transformer
> stage?
>
> Source database is UniVerse. Target database is SQL
> Server 2000. Current DataStage is version 7.0.
>


__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree

[admin]

Thank you Ken.

Edwin
+++++++++++++++++++++++++++++++++++++++++++++++++
----- Original Message -----
From: "Kenneth Bland"
To:
Sent: Tuesday, November 25, 2003 8:12 AM
Subject: Re: MultiValue Question


> If you need to normalize on multiple attributes, then
> they all must be coordinated attributes. You will
> want to define them as part of the same normalization
> group, and setup your dictionaries accordingly.
>
> FYI, my recommendation is to setup a DataStage account
> on the source server and create localized dictionaries
> of clean attribute entries. This way you can define
> proper attribute entries with correct formatting, as
> well as properly associate multiple groups. One
> Universe hash file, when normalized, could turn into
> many, I repeat, many normalized target tables because
> of rules of normalization. You have to make sure that
> your modeler and subject matter experts are aware of
> this.
>
> Good luck!
> -Ken
>
> --- Edwin Tandiman
> wrote:
> > Hi,
> >
> > Does anyone know in DataStage how to extract data
> > from a UniVerse file that has attributes with
> > multivalues data on them? I know in DS designer as
> > I define a UniVerse stage as a source, I can use a
> > "Normalize on" option. But this option only allows
> > me to normalize on a attribute not multiple
> > attributes. Do I need to create a custom function
> > or routine in DS and use it in the transformer
> > stage?
> >
> > Source database is UniVerse. Target database is SQL
> > Server 2000. Current DataStage is version 7.0.
> >
>
>
> __________________________________
> Do you Yahoo!?
> Protect your identity with Yahoo! Mail AddressGuard
> http://antispam.yahoo.com/whatsnewfree
>