Delphix Products

Expand all | Collapse all

How to make the SL algorithm for the Date OF birth??

  • 1.  How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 07:49:00 AM
    How to make the SL algorithm for the Date OF birth??

    Example: If we have DOB 12/04/1985 then how to set the SL algorithm Want to preserve YYYY 
    Date and Month should be MASKED

    Please help on this asap.



    #Masking


  • 2.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 07:53:00 AM
    Hi Pankaj,

    You should define 3 segments, 1 each for date, month and year. Then just provide the positional values to preserve the year.

    Regards,
    Mayank


  • 3.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 08:19:00 AM
    I have modified but still getting failed.please let me know what exactly wrong in that



  • 4.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 09:38:00 AM
    Don't you want the first segment to have real values from 1-31 and the masked value to be 1-28?


  • 5.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 09:58:00 AM
    Gary thanks for your comments but after doing changes also masking job is getting failed.

    Could you please let me know how we have set the SL for DOB  in details?


    NEW_BIRTH_DT              DATE (7)





  • 6.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 10:23:00 AM
    Could you please reply ?


  • 7.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 10:35:00 AM
    Could you please reply ?


  • 8.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 10:43:00 AM
    I suspect it is getting failed because of the  data type of the column. What is the error that you get on the failed masking job ?

    Btw, i suggest using the date shift algorithms for masking dates instead of using the segmented algorithm.


  • 9.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 12:32:00 PM
    Hi Pankaj,
    The Segmented Mapping will not work on a DATE type field.  You have 3 out of the box algorithms for dates, but your requirements suggest that you will need a custom algorithm.  Is this Oracle?
    To get a custom algorithm built you will need to contact Delphix Professional Services - so talk to your Delphix account team on your project.
    Regards,
    Gary


  • 10.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-06-2018 01:07:00 PM
    It is oracle gary...

    Lets assume we dont know anything ...Now please tell me how to Mask DATE column by preserving the YYYY please explain each steps.


  • 11.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-08-2018 05:28:00 PM
    Hi Gary,

    now i am using below algorithm but those are not working could you please help me on this asap. please 

    DATE SHIFT(DISCRETE) Transforms day component of date based in date

    DATE SHIFT(FIXED) Transforms date randomly by a fixed variance

    DATE SHIFT(VARIABLE) Transforms date randomly




  • 12.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-09-2018 11:16:00 AM
    Hi Gary , 

    Could you please reply or solution to mask the Date column using Delphix ?
    I have tried in all ways but date column is not getting masked please let me know which algorithm or steps i have to fallow to mask Date Column 



  • 13.  RE: How to make the SL algorithm for the Date OF birth??

    Posted 04-09-2018 11:18:00 AM
    Hi Mayank,

    Could you please tell me how to mask data column which algorithm i have to use.
    I have tried with DATE algorithm also but it is not working
    I have tried in all ways but date column is not getting masked please let me know which algorithm or steps i have to fallow to mask Date Column