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