not replicate unsatsifed condition in colmap
Hi All,
Need help on this.
I need to have a condition/clause or function or statement where if one condition is satisfied then one result is to be replicated but if that condition is not satisfied then nothing should get replicated for that column in colmap.
MAP $TBBD00.ICAFT7D1.CSTT, where (TYP = " "), target crbd01sch.customer,
COLMAP
(
PHID = PAN,
CUSTOMERTYPE = TYP,
);
MAP $TBBD00.ICAFT7D1.CSTT, where ((@STREXT(CUST_INFO_1,11,11)) = " "),target crbd01sch.customer,
COLMAP
(
PHID = PAN,
INFO1 = CUST_INFO_1,
);
As seen in above 2 statements, in firstatement ,The column 'typ' will get replcaited if it is blank to the customertype column. otherwise it wont.
0