Merging into an temporal table

Database
The Teradata Database channel includes discussions around advanced Teradata features such as high-performance parallel database technology, the optimizer, mixed workload management solutions, and other related technologies.
Visitor

Merging into an temporal table

We ETL data from XML into a table.

We want to make the table a temporal table.  The ETL will remain the same, from XML to a non-temporal staging table.

I want to merge into the temporal table from the staging table, but only if something in the row has changed.

In a previous post (http://community.teradata.com/t5/General/Conditional-Merge-Into/td-p/57582) Jim Chapman says: "The Teradata MERGE INTO statement automatically filters out unneeded updates"

 

a sample merge statment:

 

SEQUENCED VALIDTIME
    MERGE INTO TABLE_TEMPORAL A USING
(SELECT ID, A, B, C, D, E,  FROM TABLE_NONTEMPORAL) AS NEWROW
    ON (A.ID= NEWROW.ID)
    WHEN MATCHED THEN
    UPDATE SET A = NEWROW.A, B = NEWROW.B, C = NEWROW.C, D = NEWROW.D, E = NEWROW.E;

 

Will this UPDATE only happen if A or B or C or D or E is different (or a combination of differences) but be skipped if all values are the same.

Thanks

Keith

thanks