Advanced-etl-processor
Update/Delete Records
In order to Update/Delete records you must specify update key.
For the example provided below, Advanced ETL Processor will execute the following SQL
(Update key is CustomerId, OrderNo).
Add New And Update Old Records
Select count(*)
from [DEMO].[dbo].[orders]
where CustomerId=? And OrderNo=?If any records found Advanced ETL will update them by executing
Update [DEMO].[dbo].[orders]
set orderdate=?,
amount=?
where customerid=? And OrderNo=?If no records found Advanced ETL will add new records
Update Records
Update [DEMO].[dbo].[orders]
set OrderDate=?,
Amount=?
where CustomerId=? And OrderNo=?Delete Records
Delete from [DEMO].[dbo].[orders]
Where CustomerId=? And OrderNo=?
It is also possible to manually edit Insert/Update/Delete/Count SQL.
Tick user defined SQL than edit every SQL statement individually.
To regenerate the SQL statements clear it and open it again.
To regenerate the SQL statements clear it and open it again.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum