Lookup table is a new feature in OBIEE11g.
Uses of Lookup Table
Uses of Lookup Table
• Resolve code columns and get description/name values from a lookup table.
• It can also be used for checking the currency conversion values from a daily updated source.
There are 2 types of lookup tables.
Sparse Lookups – A sparse lookup basically means that the main driving table does not
necessarily have corresponding lookup values in the lookup table for all the id values. This can be
considered to be an equivalent of a Left Outer Join.
Dense Lookups – A dense lookup basically means that the main driving table will have matching
lookup values in the lookup table for each of its unique id value. This can be considered to be an
equivalent of an inner join.
Below are the screenshots of the steps with instructions mentioned. Hope you get what you're looking for.
• It can also be used for checking the currency conversion values from a daily updated source.
There are 2 types of lookup tables.
Sparse Lookups – A sparse lookup basically means that the main driving table does not
necessarily have corresponding lookup values in the lookup table for all the id values. This can be
considered to be an equivalent of a Left Outer Join.
Dense Lookups – A dense lookup basically means that the main driving table will have matching
lookup values in the lookup table for each of its unique id value. This can be considered to be an
equivalent of an inner join.
Below are the screenshots of the steps with instructions mentioned. Hope you get what you're looking for.
No comments:
Post a Comment