Project:
10 workflows in 3 folders (A, B, and C)
Desired Execution:
nFolder A workflows depend
on a master go file from Oracle CDC.
Run these workflows every time a master CDC go file is presented
(usually hourly).
nRemove the ancillary Project’s go file if it was not
consumed. Place the ancillary Project’s go file after Folder A workflows
finish.
nFolder B and C workflows depend on Folder A finishing and
appearance of a secondary
CDC go file.
nIf the secondary CDC go file does not appear, capture
and sort records that were
deleted by Folder A’s execution into date-time stamped text files for later processing by folders B and C.
nIf the secondary CDC go file does appear, consume it,
then create list files for
each group of date-time stamped text files that are read by workflows in folders B and C.
nAfter folders B and C finish, delete the list files,
remove any empty text files, then
archive and compress the remaining text files into a single date-time stamped .tar file.
nDo not restart Folder A workflows until Folder B and C
workflows finish and the
archival and compression process is successful, even if CDC presents a master go file before this process completes.