How to load data from Oracle to Teradata

UDA
Rao
Enthusiast

How to load data from Oracle to Teradata

HI,

We have OLTP on Oracle database. We are planning to get the data from Oracle to Teradata. Which is the best way to get without using the 3rd party tools.

And, is there any way, we can directly connect to Oracle db and get the data. I suppose the FastLoad or multi loads needs first to convert to flat file and then load.

Thanks in Advance
Rao
2 REPLIES
Enthusiast

Re: How to load data from Oracle to Teradata

Hi ,
I advice you to use OLELoad for loading data from Oracle to Teradata.

Regards,
Aravind
Enthusiast

Re: How to load data from Oracle to Teradata

If you are V2R6 and above, you may want to consider TPT.
I think it may be available starting V2R6.1 and TTU 8.1.
You will however need to buy licences for different operators.

Vinay