UV Stage

phil · Post by **phil** » Fri Feb 13, 2004 10:46 am

In which situation you used the UV Stage unless a hashed file??

Thanks.

ds_developer · Post by **ds_developer** » Fri Feb 13, 2004 11:07 am

The most obvious is to pull data from a Universe database (other than the DataStage database). Otherwise, I have used the UV stage when I have a multi-valued hash file with an association field. The UV stage allows you to denormalize on the association field.

John

ds_developer · Post by **ds_developer** » Fri Feb 13, 2004 11:08 am

The most obvious is to pull data from a Universe database (other than the DataStage database). Otherwise, I have used the UV stage when I have a multi-valued hash file with an association field. The UV stage allows you to denormalize on the association field.

John

kcbland · Post by **kcbland** » Fri Feb 13, 2004 11:14 am

Give this a read:

viewtopic.php?t=85364

Paul Preston · Post by **Paul Preston** » Mon Feb 16, 2004 8:08 am

One of the most useful features of a UV table is that it can be used to return mutiple records from a single look up record. Hash files can only return single rows from a lookup. When using larger UV tables remember to index columns as needed with the CREATE INDEX command.