MultiValue Question
Posted: Tue Nov 25, 2003 9:12 am
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
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