TPT and stored procedure(s)

Tools & Utilities

TPT and stored procedure(s)

I'm sure there are many ways of skinning this cat and I'd appreciate any suggestions.

What I need to to is export account data on >200k accounts from one Teradata database (TD #1), import it into another (TD #2), query that database for additional transaction data, export THAT (larger) result set back into the first database (TD #1), perform additional processing in a stored procedure which then appends the final result to another table in TD #1.

So what I'm looking for is a mechanism to "wrap" something like TPT or FastLoad and stored procedures into one package that only requires one command to execute.