ETLRoute Table

The ETLRoute controls how types of files get routed to ETL exploitation processes. A "route" in Truxton can be thought of a type of load configuration. It controls the path that files will take through the ETL processes in the exploitation layer. The configuration of a load has two parts, the options specified for the Load

CREATE TABLE "ETLRoute" (
    "LoadConfigurationID" integer DEFAULT 0 NOT NULL,
    "FileTypeID" smallint DEFAULT 0 NOT NULL,
    "ETLQueueName" text NOT NULL
);