ETL+ Load Append Example 1
Example of a target table that results from a Load Append from a .csv source file.
Initial Load Append
Data Source
Target Table ( SQL Server data warehouse)
Source data as displayed by ETL+ Preview page
Data in SQL Server data warehouse table
“new” Column : To help illustrate the output of load append, in this example the ‘
new' column is updated by a date-time stamp during the load process.
2nd Load Append
Data Source
Target Table
Source data does not change.
ETL+ Configuration for this Example
For this example the SQL in the Extract SQL Statement panel and the Design page was customized to include a date-time stamp in the new column. The column is assigned the current date-time when when Load Append is run.
Created a new column named new on the Extract SQL Statement panel to hold a date-time stamp.
The current date-time stamp is assigned to new on the Design page.
The new column is assigned a current date-time value by T-SQL Expression.
The source driver for this example is ETL+ Source Driver for Text Files (.CSV).
The SQL that can be used Extract SQL Statement panel depends on the source driver. The source driver for this example does not support the use of the getdate() function in the Extract SQL Statement panel.