TimeStamp and mini-ETL (extract, transform, load)

Posted by Tomaz.tsql on SQL Blogcasts See other posts from SQL Blogcasts or by Tomaz.tsql
Published on Sun, 02 Jan 2011 10:46:00 GMT Indexed on 2011/01/02 11:57 UTC
Read the original article Hit count: 408

Filed under:
|
|
|
Short example how to use Timestamp for a mini ETL process of your data. example below is following: Table_1 is production table on server1 Table_2 is datawarehouse table on server2 where datawarehouse is located Every day data are extracted, transformed and loaded to dataware house for further off-line usage and data analysis and business decision support. 1. Creating the environment if object_id ('table_1') is not null drop table table_1; go if object_id ('table_2') is not null drop...(read more)

© SQL Blogcasts or respective owner

Related posts about DWH

Related posts about timestamp