Kettle 6.1 Extracting data by Time cycle increment

Scenario: Assume that there is a large amount of data in a table, you need to cycle the incremental extraction by a single time

Method: The loop call is implemented mainly through the job itself, similar to the loop of function self-invocation.

1.JOB Full Image:

2. Get the increment time and set the incremental time environment variable

3. Get this incremental data with incremental environment changes

4. Determine if the increment time is greater than the current time, and determine whether to continue the increment

5. Invoke the total job itself to implement a circular call

Kettle 6.1 Extracting data by Time cycle increment