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.
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
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?