DSXchange

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

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.

BTW what is the need for the database to get loaded after loading sequential file?

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.