
210 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
5.2.4 Application-period temporal tables
When the application-period temporal tables have been defined and deployed to
DB2 using InfoSphere Warehouse 10.1, we can examine how to manipulate and
query these tables. We continue to use our simple example table tracking our
customers’ use of our loyalty program. We begin by looking at the table insert
and then move onto other, more interesting, actions.
Inserting data into an application-period temporal table
Different from the system-period temporal tables discussed previously in this
chapter, row insertion into ...