Can we Delete Data in source (Oracle ) table after loading data into Target (Teradata) table in TPT?

Tools
Enthusiast

Can we Delete Data in source (Oracle ) table after loading data into Target (Teradata) table in TPT?

Hello Gurus,

We recently started using the TPT so not familiar with how purging the source data works out throuth TPT. I have been going through the Teradata Parallel Transporter user guide and i see that there are some Standard Operators which can delete data from Teradata only. My source table is a Oracle table and i would like to delete the data after i load it to Teradata. 

Can you guys help me in this regard? 

Thanks

Siva Nelluri

2 REPLIES
Teradata Employee

Re: Can we Delete Data in source (Oracle ) table after loading data into Target (Teradata) table in TPT?

TPT is a suite of load tools for Teradata.

We are able to pull data out of Oracle, but TPT does not perform any other actions against non-Teradata databases.

-- SteveF
Enthusiast

Re: Can we Delete Data in source (Oracle ) table after loading data into Target (Teradata) table in TPT?

hmm .. Thanks for replyin to my post.