exasol-dawa-udfs

Overview

Quick start

1. Create Schema

Create a new schema eg. ETL_UDFS.

CREATE SCHEMA ETL_UDFS;

Sources

txid

insert into <table> select ETL_UDFS.dawa_txid(<txidfra>, <txidfra>)

example:

Initial extract

insert into <table> select ETL_UDFS.dawa_txid(NULL, NULL)

Incremental extract

insert into <table> select ETL_UDFS.dawa_txid(100, 1000)