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

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • In Progress
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.
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb
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
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
I have modified but still getting failed.please let me know what exactly wrong in that
Photo of Mayank Ahluwalia

Mayank Ahluwalia

  • 708 Points 500 badge 2x thumb
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.
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
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 
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,946 Points 1k badge 2x thumb
Don't you want the first segment to have real values from 1-31 and the masked value to be 1-28?
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
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)
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
Could you please reply ?
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
Could you please reply ?
Photo of Gary Hallam

Gary Hallam, Official Rep

  • 1,946 Points 1k badge 2x thumb
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
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
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
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
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.
Photo of pankaj

pankaj

  • 492 Points 250 badge 2x thumb
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