default value for missing data in parent table on LOAD

[#1]

Dear All,

i have two tables 1 ) ScripMaster and 2) ScripDetail

ScripMaster have two fields ScripCode (PK) , scripType;

ScripDetail  have ScripCode(FK) and ScripId, Count;

some time what happen there are some ScripCode which is there in ScripDetail table but not in ScripMaster, So due to this i am not able to know the ScripType. In this type of condition i want to assign a default ScripType to that particular ScripCode.

Kindly help how can i do while loading the data.

[Anonymous · Accepted solution]

ScripMasterMap:

mapping load

ScripCode ,

scripType;

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

;

ScripDetail Map:

mapping load

applymap('ScripMasterMap',ScripCode,'Your Default')

ScripCode ,

ScripId,

Count

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

;