All Forums Tools
NMadson-3173 44 posts Joined 09/06
13 Jul 2007
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.TIA,Nolan

You must sign in to leave a comment.