Question: What properties would I need to create a Temporal Table in erwin Data Modeler?
1. Create a Temporal Table in erwin Data Modeler by first creating two columns with datatype: 'Datetime2' (SQL Server) 'timestamp with timezone' (Teradata), in the following example they are labeled 'Start' and 'End':
2. Navigate to the Table Editor by right-clicking on the table and selecting 'Table Properties'. In the Table Editor click the General tab and fill in the Temporal Options:
- Check the box 'Temporal Table'
- In the 'Period Start Column' and 'Period End Column' dropdown choose the corresponding column: