Next >> << Prev

Tour Part 6: Run Pre-Conditions

Add logic, run exports and loads conditionally:

Check the result of an SQL Query before running an Export or Load


Execute exports and loads depending on the result of an SQL query ran against any data source.

Query Pre-Conditions
 
The export or load will run only if data has been delivered today

(i.e. the control table T_CONTROL contains at least 1 record with a delivered date of today).

Check the presence or content of a File before running an Export or Load


Execute exports and loads depending on the existence of a file or its content.

File Pre-Conditions
 
The export or load will run only if the file "Sales Delivery.txt" exists and its content begins with "OK".

Note: The pre-conditions can be used together, i.e. you can have a query and a file pre-conditions. In that case both pre-conditions must be satisfied.