Delphix Products

  • 1.  Segment mapping Special Character Handling

    Posted 01-18-2019 03:38:00 PM
    Hi there, I understand that the input character set for Segment mapping Algorithm is US-ASCII 7 bit Alphabetic characters (letters and numbers). Which includes !@%^ etc. Why does the masking fail when special characters are encountered? Also I am trying to ignore the 1⁄2 in one of the columns, which is not from the above character set, is there any way of doing this? I am using ALPA-NUM segment mapping.
    #Masking


  • 2.  RE: Segment mapping Special Character Handling

    Posted 01-18-2019 09:04:00 PM
    Hi madhu,
    I think this answers both of your questions, please let me know. 
    I asked our team here and one of our engineers stated:
    SM covers only a-z, A-Z and 0-9
    Any characters other than that BREAK the logic and need to be added to the ignore characters list - including @, blank,-,_,....
    So, that would definitely be the issue in this scenario, correct? 

    Thanks,
    Michael


  • 3.  RE: Segment mapping Special Character Handling

    Posted 01-18-2019 09:42:00 PM
    Thanks Michael, I have worked around with idea so far. However I need to ignore 1/2 (Symbol) which is in our oracle data, which the ignore list is not ignoring even after adding to it. I understand it only takes ascii 7, and this symbol is not that. Is there a workaround to ignore such special characters?


  • 4.  RE: Segment mapping Special Character Handling

    Posted 01-19-2019 08:03:00 AM
    Hi madhu, One option I think of is setting this sign as a segment it self and not define any masking value for it or play with pre and post scripts on masking. Regards, Mouhssine


  • 5.  RE: Segment mapping Special Character Handling

    Posted 01-21-2019 08:14:00 AM
    Hi, thanks for the response, this character is not bound to exist in the same position, it varies. I think post steps will be the only option..