Skip to content

Opening book details…

Can I read SQL Table and Sequence Creation Guide on EtoBox?

SQL Table and Sequence Creation Guide by lol wa is a document available to read on EtoBox.

What is SQL Table and Sequence Creation Guide about?

The document defines tables and sequences to store time data from multiple sources in a data warehouse. A stage_time table is created to load raw time data using a trigger to populate the ID column from a sequence. Data is bulk inserted from different source tables. Clean_time and bad_time tables are created with sequences to store valid and invalid loaded records respectively.

Author
lol wa
Language
EN