Skip to Main Content
Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
book

Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

by Whei-Jen Chen, Pat Bates, Timothy Donovan, Garrett Fitzsimons, Jon Lind, Rogerio Silva
October 2012
Beginner to intermediate content levelBeginner to intermediate
506 pages
12h 43m
English
IBM Redbooks
Content preview from Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
192 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition
5.2.2 System-period temporal tables
Now that you have an understanding of how to create and enable tables for
system-period temporal data management, we shift our attention to how to
manipulate and query these tables. We start with describing what happens when
data is inserted into the base table.
Inserting data into a system-period temporal table
When data is inserted into a system-period temporal table, the new rows are
added to the table just like any other regular table with the exception of how the
new TIMESTAMP columns are assigned. The INSERT statement ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Reinventing the Organization for GenAI and LLMs

Reinventing the Organization for GenAI and LLMs

Ethan Mollick

Publisher Resources

ISBN: 0738437255Purchase book