Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Creating a Data Subset
  8. Performing a Data Masking Operation
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. 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.