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.
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.
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
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.