This might seem like a simple question but I have a Transform with 3 outputs... 2 sequential files and 1 database file. I want to have the database file execute after all the data has been moved into the sequential files, is there a contraint I can use that only activates the database link after the very last record has been processed?
No. You'll need to send your database output to another passive stage first and then on to the database. Or, set your commit (if rollback space allows) to 0 and make the database the last link in the execution order. If the files finish first, then the database link will close issuing the commit.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
If one of your two output sequential files has the same columns and contents as your database then you can use that output file as an input stream to your database stage. This would effect a sequential load.
After the two sequential files process I want to update a tracking file in oracle and create a header and trailer record... I though it would be cleaner if I could add wait function to the transform, instead of having the next steps be an output from the sequential files.
I guess your trailer record consits of informations like the number of rows processed.
Better post process your job. User LinkInfo or UserStatus to pass the value the next job.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'