Mapping load or lookup tables

[#1]

Hi Everyone,

I have a very large data set (400 variables).  A lot of them are coded using numerical codes that relate to a string (not in the table).  I have a data dictionary that tells me what these values relate to.  I could create a lot of little tables that link to my master table for each coded variable, which is how I would normally do it for a small number of variables.  Is this when I should be applying a mapping load?  Would I require a map for every variable?

Thanks

Gareth

[brenner_martina]

Hi,

yes, working with mapping tables means for every "variable" an own Mapping Table and Applymap in your facts table.

But you can load the "Variables" with their text also by joining them:

Factstable:

Load Field1,

       Variable1,

        ...

From ...;

Left Join (Factstable)

Load Variable1,

        Text1

From VarTable1;

...

Greetings from Munich