Breadcrumbs

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)

image-20231101-010901.png
Source data as displayed by ETL+ Preview page
image-20231101-012522.png
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

image-20231101-010901.png
Source data does not change.
image-20231101-013020.png


ETL+ Configuration for this Example

image-20231101-014700.png

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.

image-20231101-013459.png
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.
image-20231101-013952.png
The new column is assigned a current date-time value by T-SQL Expression.
:notes5:


  • 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.