syn key remove

[soniasweety]

hi all,

I have one table with columns like below

A:

Id,

cost,

item,

Engineer

Programmer              these two having the  values  ID's

and I have a master table to map this

mst_group:

"UserID" as Engineer,

    "UserID" as Programmer,

       UserName

from  qvd;

when I load this am getting  synthetic key   how can I resolve this?

here in master table  all user names belongs to eng and prog are there.

Thanks

[Anonymous]

Try a Mapping Load and then ApplyMap(), maybe something like but I not sure I have properly understood your underlying data and I have typed the below free hand so it may have typo's.

MapUserName :

Mapping Load

    [UserID] ,

    [UserName]

from  qvd;

A:

Id,

cost,

item,

ApplyMap ( 'MapUserName' , [Engineer]        , null() )  as [Engineer Name] ,

ApplyMap ( 'MapUserName' , [Programmer]  , null() )  as [Programmer Name]

from ..............