Temporal Table

Database
Enthusiast

Temporal Table

Hi,

I am looking to create temporal tables in the Warehouse, If i create temporal table with 10 columns and I only want that the temporal history to be maintained for 5 columns is that possible. 

For eg I have table customer with following columns

customerid

firstName

lastname

Address

Phone no

Customer enrolled date

transaction_time

So in this table I am only interested in tracking the changes in phoneno, is this possible in one table or do I have to create a seprate temporal table for customerid and phone no