Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Glossary

Effective Dates Generation Parameters

Effective Dates Generation Parameters

Create effective dates generation rule for the date data type.
The following table describes the parameters that you can configure to generate data for effective dates:
Parameter
Description
Start Date/Time
The date and time at which you can start to generate dates.
End Date/Time
The date and time at which you can stop to generate dates.
Exclude
The days of the week that you do not want to include in the generated dates. You can enter up to two days, and both the days cannot be same.
Effective Start Date
The column name in the target table where you want to put the generated effective start date. Default is the column name in which you create the effective dates generation rule. You can change it to any other available column name.
Effective End Date
The column name in the target table where you want to put the generated effective end date. You can select any column other than the effective start date.
Grouping Column
The column that determines how you group the data to generate effective dates in the target columns.
Invalid Values
Any value with effective end date greater than the effective start date. If effective start date is less than effective end date of the previous record for the grouping column, the values are not valid.
This parameter has default rule selected and you cannot change the rule. You enter the percent for values that are not valid.