Delphix Products

Expand all | Collapse all

Description of Date Shift default algorithms

Jump to Best Answer
  • 1.  Description of Date Shift default algorithms

    Posted 12-12-2017 01:36:00 PM
    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


  • 2.  RE: Description of Date Shift default algorithms

    Posted 12-12-2017 01:44:00 PM
    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


  • 3.  RE: Description of Date Shift default algorithms
    Best Answer

    Posted 12-12-2017 01:52:00 PM
    Hi Hims,
    could you please write down some examples?

    Original Date -> Masked Date

    for each of three types.

    Thank you.
    Gianpiero


  • 4.  RE: Description of Date Shift default algorithms
    Best Answer

    Posted 12-12-2017 02:15:00 PM
    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


  • 5.  RE: Description of Date Shift default algorithms

    Posted 12-12-2017 02:42:00 PM
    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


  • 6.  RE: Description of Date Shift default algorithms

    Posted 12-12-2017 03:08:00 PM
    Thank you Hims. You have been extremely helpful. Much appreciated!

    Renee


  • 7.  RE: Description of Date Shift default algorithms

    Posted 12-27-2017 03:21:00 PM
    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


  • 8.  RE: Description of Date Shift default algorithms

    Posted 12-27-2017 04:12:00 PM
    new question Please reference the new conversation here: Using Date Shift to mask varchar field...