Question: erwin r9.7 DM implemented a way to create temporal tables for Teradata DBMS.
I have seen the physical Table level attribute "Temporal Type", but there is no dropdown to select either TRANSACTION, VALID, or both.
The requirement for a Temporal Table in Teradata is to have at least two columns with ‘TIMESTAMP’ or ‘TIMESTAMP WITH TIME ZONE’ data types.
Then create another column using DERIVED PERIOD data type.
That will expose another option which will then allow you to add the Starting Time and Ending Time and also select the Temporal clause for the Table.
Attached is a sample model Teradata_Temporal_Sample.erwin .