IS NULL Mapping Load

[#1]

Hi all,

Please I will like to check whether this script is correct:

Map_Sales:
MAPPING LOAD
IF(IsNUll("SalesID"), '1001', "SalesID") AS "SalesID",
IF(IsNUll("SalesName"), 'Not Known', "SalesName") AS [SalesType];
SQL SELECT *
FROM "Systems"."Sales";

Regards,

[Roop]

You have done the Mapping Load that creates the map - Then you need to perform the ApplyMap('Map_Sales' .....

Otherwise it is fine - but you may wish to group the SalesID and SalesName to ensure there are no duplicates - it would still work but be a bit more efficient