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 Example

Effective Dates Generation Example

You want to generate start dates and end dates for customer addresses.
The target table has two customers. Each customer has one identification number. The table has three address rows for each customer. You choose a date range to generate a random effective start date for each customer. You select an effective start date column to put the start date into. You select an effective end date column to put an end date into. You select the customer identification number as the grouping column.
The rule generates a random start date for the first address row for each customer. The rule generates a random end date that occurs after the start date. The rule generates a start date for the next row that is after the end date of the previous row.
The following table shows a sample table with the generated data:
Customer ID
Address
Start Date
End Date
1111
55 Crestwood Dr
11/20/2001
06/17/2003
1111
200 Larkin St
06/18/2003
04/16/2004
1111
1000 Cooke Ln
04/17/2004
08/16/2012
2222
12708 Danbrooke Ct
03/06/2008
05/19/2010
2222
1200 S Sixth Ave
05/20/2010
07/06/2011
2222
2243 Creeksie Ct
07/07/2011
11/24/2013