When you deploy a staging- or data warehouse table from timeXtender, a number of physical tables will be created.
The two primary tables are:
<TableName>_R is the Raw table, that contains the records as they where extracted from the data source, with eventual lookups added.
<TableName>_V is the Valid table, that contains the records as they are after the data cleansing and data quality process has executed.
It is possible to avoid having the Valid table if the table is not collecting history or is incrementally loaded by de-selecting "Physical Valid Table" in the Table settings screen.
On the Project Level, you can change the setting "Postfix Valid" table to ommit the _V postfix on the Valid table instances.
The reason for having data in a raw and valid instance is primarely to help test and troubleshoot transformations and secondly to avoid having to reload the raw data from the source if the data cleansing process fails for some reason.
There is a truncation setting on the tables where you can choose to truncate the raw table after data cleansing. This option will, however not free any space in the database, since the space allocated will still be reserved for the table - and the space will be needed on the next load.
This article applies to: timeXtender 4.5, tX2012, TX2014. Last updated: 2014-03-24.