Delphix Products

Can someone explain what the default algorithms Date Shift (fixed), Date Shift (variable), and Date Shift (discrete) actually do and how they differ? I have not been able to find any documentation that provides that information.

Thank you,
Renee
#Masking

Hello Renee,
Delphix offers 3 different types of algorithms for changing dates:

1. Date Shift ( Variable)
    Moves the date randomly within same month
2. Date Shift ( Fixed)
    Moves the date by a fixed number of days per installation( for specific cases only)
3. Date Shift ( Discrete)
    Computes the day component based on the month and year component of date hence generates the same masked date each time.

Hope this helps, let me know of any followup question.
Thanks
--Hims

Hi Hims,
could you please write down some examples?

Original Date -> Masked Date

for each of three types.

Thank you.
Gianpiero

Thank you Hims, that was very helpful. From your description of the Discrete option, is that the one we should use if we want to maintain referential integrity across tables? Or do they all maintain referential integrity?

Renee

Hi,

E.g. of 3 date shift algorithms


Notes:

• All 3 algorithms maintain day components in the same month to maintain date characteristics ( Senior -> Senior, Minor -> Minor).
• Fixed changes to the same date always and should be used in special cases only.
• Discrete creates the same date and is used to maintain RI between tables/files ( Most commonly used)
• Users can mask any Julian/Gregorian dates.
• For dates in varchar/text columns or in files, Users can specify date formats in the drop down on inventory page and use help ( screengrab below)
• Additional algorithms for specific needs are available via Delphix ProServ, please contact your Delphix Rep.
• 
  

Thanks
--Hims

Thank you Hims. You have been extremely helpful. Much appreciated!

Renee

Using the Date Shift(Discrete) algorithm, I need to mask a varchar field that has the data in MM-DD-YYYY format, but that is not a date format available when doing the inventory. Is there a way I can add a new date format (ie MM-DD-YYYYY) to the default algorithm?

Thanks,
Renee

Hello Sir,


 I a m new to the  Delphix masking.  I have retirement to  mask the Date to the  Default 15 of that given month  and Year. so what type of Date Algorithm will be used in this scenario.  example  the output should be yyyy-mm-15 . i am using the Flat file with delimiter as the data source.

Thanks in Advance.


------------------------------
GEETHANJALI DEVI
Business Objects Developer
Genworth Financial
------------------------------

Original Message:
Sent: 12-27-2017 04:20:00 PM
From: Renee Greenley
Subject: Description of Date Shift default algorithms

Using the Date Shift(Discrete) algorithm, I need to mask a varchar field that has the data in MM-DD-YYYY format, but that is not a date format available when doing the inventory. Is there a way I can add a new date format (ie MM-DD-YYYYY) to the default algorithm?

Thanks,
Renee

Thank you for splitting this off into the thread found here.

------------------------------
Michael Torok
Director of Knowledge and Community Management
Delphix
------------------------------

Original Message:
Sent: 04-06-2020 10:17:47 AM
From: GEETHANJALI DEVI
Subject: Description of Date Shift default algorithms

Hello Sir,


 I a m new to the  Delphix masking.  I have retirement to  mask the Date to the  Default 15 of that given month  and Year. so what type of Date Algorithm will be used in this scenario.  example  the output should be yyyy-mm-15 . i am using the Flat file with delimiter as the data source.

Thanks in Advance.


------------------------------
GEETHANJALI DEVI
Business Objects Developer
Genworth Financial

Original Message:
Sent: 12-27-2017 04:20:00 PM
From: Renee Greenley
Subject: Description of Date Shift default algorithms

Using the Date Shift(Discrete) algorithm, I need to mask a varchar field that has the data in MM-DD-YYYY format, but that is not a date format available when doing the inventory. Is there a way I can add a new date format (ie MM-DD-YYYYY) to the default algorithm?

Thanks,
Renee

new question Please reference the new conversation here: Using Date Shift to mask varchar field...