NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
[[Image:Staging_Area_Model_Hazard.png|center|800px]]
===Main object tables===__NOEDITSECTION__ ===Other tablesSpecial table===__NOEDITSECTION__
{| class="wikitable" width="1000'"
|-
| width="150pt" | '''Table name'''
| width="850pt" | '''Description'''
|-
| align="left" | '''ETLHISTORY'''
| align="left" | This table is the only one that does never get dropped from the staging area, but persists as the database is re-generated again and again (see [[Staging Area Generator]]). I contains information about all the staging area generations on a specific database (i.e. for example when a staging area database with the same name is generated regularly, e.g. once per day or week). It has two columns:
* '''etlruntime''': this is the timestamp of the start of the generation
* '''runtime''': this is the time in minutes that the generation took
Having x rows in this table means that the database has been generated x times, and allows to keep a history of the individual runs. It also allows to determine how old the information in the staging area is, by looking at latest timestamp.
|-
|}
