Tags for temporal
Error Dropping a Column in a TRANSACTIONTIME Table
Using Teradata Database 14.0.5 in a Virtual Machine and testing the following steps specified in a reference document, "Temporal Table Support" (Release 14.0) page 36 "Converting Period or DateTime Columns to a Transaction-Time Column", an error was encountered in an ALTER TABLE step to DROP the old PERIOD column: (Is there a missing step that will preven
temporal Temporal table TRANSACTIONTIME Table transactiontime NONTEMPORAL alter table DROP COLUMN
Strange Temporal Behaviour
Hi all, I see some strange behaviour with some temporal operations which I can't explain myself. I developed a macro to maintain a bi temporal table based on transaction data.  The macro does the following steps: 1. delete all from a volatile temp table  2. insert select from a non temporal table into the vt tmp table
temporal
How to apply custom period of validity for valid time tables during the updates
I have a requirement to load the data from 2009 onwards and snapshots will be deilvered with a one week of gap starting from 2009-01-01. I am planning to use valid time temporal table to hold the data becuase business team wants to have time travel back capability in data. My input data snaps lookas as follows: Data as of 2009-01-01
temporal custom period of validity
9334 Invalid constraint definition
This error was received after executing the following DDL statement for bitemporal table:  
temporal bitemporal Constraint Constraints ddl ddl statement
Getting error while copying data from one temporal table to other temporal table
CREATE MULTISET TABLE XXX.electronicaddress ,NO FALLBACK ,      NO BEFORE JOURNAL,      NO AFTER JOURNAL,      CHECKSUM = DEFAULT,      DEFAULT MERGEBLOCKRATIO      (       AddressId VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
temporal validtime transactiontime teradata
Temporal concept
Hi ,   I am using SCD type 2 in my project.Below is the example of versioning which i maintain. empno ename sal eff_dt  end_dt  curr_in rcv_in 1 a 100 2013-01-01 9999-12-31 1 1 Above is an active record because end_dt shows as high end date and curr_in shows as 1.
temporal
When to use Temporal features
When during the course of a project, should you incorporate temporal features into the design of the database?  Should a roadmap be developed for projects to follow? 
temporal
CREATE compound Temporal view to allow AS OF Reporting
Hello,
temporal
Teradata Database 14.10 SQL Solutions for Real-World Temporal Problems
Data Warehouses are known for storing data over time, both historical point-in-time transactions as well as temporal data that is valid over a range of time...
sql temporal Normalize 14.10 Time-Series
R14.10 Temporal Feature Deep Dive
When Teradata released its new temporal capabilities in 2010, it caused us all to start to thinking differently about the element of time in the Data Warehouse by providing powerful tools for managing and navigating temporal & bitemporal data structures. With the release of Teradata R14.10, we will be challenged still further.
temporal valid time transaction time time series

Pages