Map and convert 3 columns in the table that may have binary_double Infinity values.

MAP Src_schema.table, TARGET Dst_schema.table, COLMAP ( USEDEFAULTS, ENTRY_AMT = @IF ( @STRFIND( @STRUP(columnA) , ‘INF’) ,9999999999999, columnA),columnB = @IF ( @STRFIND( @STRUP(columnB) , ‘INF’) ,9999999999999, columnB),columnC= @IF ( @STRFIND( @STRUP(columnC) , ‘INF’) ,9999999999999, columnC));