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?
-Keevil
Transform Output Question
Moderators: chulett, rschirm, roy
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
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.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>