How Mapping can be used when a column doesnt exist in a table ?

[nishanthi_8]

I have two tables concatenated and there doesnt exist a column name in one of the table. How it can be achieved via ApplyMap() ?

DIMENSION TABLE:

USER ID,

ORG SUB_CATEGORY;

CONCATENATE

USER ID,

ORG NAME,

ORG SUB_CATEGORY;

     In the above example i need ORG NAME to be used in ApplyMap() so that ORG SUB_CATEGORY can also be used for further manipulations.

[arulsettu]

like this

maptable:

mapping load

USER ID,

ORG SUB_CATEGORY;

second table:

USER ID,

applymap('maptable',ORG NAME) as orgname,

ORG SUB_CATEGORY;