Best way to do from/to (Get an ID and load a value for a element)

    Best way to do from/to (Get an ID and load a value for a element)

    Greetings Brazilian!

    I'd like to know which is the best way to make the comparation like from/to, (between IDs and Descriptions), to load values for a cube?

    Example (source):
    Table "Products" (ID, Group, Subgroup, Product, Price)
    Table "Salesman" (ID, Site, Name)
    Table "Sales" (ID_Salesman, ID_Product, Date, Amout)

    Example (cube_sales):
    Dim. Products; <- This dimension has the base elements that I want to fill
    Dim. Salesman;
    Dim. Period;

    Solutions:
    Opt1.: Create a data cube like the table "Products" and Extract this information with the ETL when loading the values for the cube_sales?

    Opt2.: Create a "Constant Table" on the ETL project like the products table and Extract....?

    Opt3: Make a field transformation on the ETL to convert IDs to description during the loads?

    Note: Our products are volatiles comes and goes quickly, i mean, they needs constant manual update.
    Atenciosamente,
    Matheus Luz
    Cel.: 55 11 97053 - 7945
    Site: dimat.com.br
    E-mail: matheus@dimat.com.br