Description of Date Shift default algorithms

  • 0
  • 1
  • Question
  • Updated 5 months ago
  • Answered
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
Photo of Renee Greenley

Renee Greenley

  • 604 Points 500 badge 2x thumb

Posted 5 months ago

  • 0
  • 1
Photo of Hims

Hims, Employee

  • 1,936 Points 1k badge 2x thumb
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
Photo of Gianpiero Piccolo

Gianpiero Piccolo

  • 1,220 Points 1k badge 2x thumb
Hi Hims,
could you please write down some examples?

Original Date -> Masked Date

for each of three types.

Thank you.
Gianpiero
Photo of Renee Greenley

Renee Greenley

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

Hims, Employee

  • 1,936 Points 1k badge 2x thumb
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
(Edited)
Photo of Renee Greenley

Renee Greenley

  • 604 Points 500 badge 2x thumb
Thank you Hims. You have been extremely helpful. Much appreciated!

Renee
Photo of Renee Greenley

Renee Greenley

  • 604 Points 500 badge 2x thumb
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
Photo of Jaclyn Schoof

Jaclyn Schoof, Community Manager

  • 5,092 Points 5k badge 2x thumb
new question

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