topic Re: Load Oracle table to teradata without extract transformation in sas di in SAS Data Management

Load Oracle table to teradata without extract transformation in sas di

Riteshdell — Fri, 17 Feb 2017 23:29:36 GMT

hello All,

Some body has asked me a question in a interview related to SAS DI.

I have Oracle database as Source and Teradata database as Target.

How can we load tables ORacle to Teradata with out using Extract transformation.

Is it poosible , if yes.

then How?

Thanks in advance.

Re: Load Oracle table to teradata without extract transformation in sas di

SASKiwi — Fri, 17 Feb 2017 23:55:50 GMT

Of course. I don't use SAS DI but I'm sure you can put your own SQL queries into a DI job, one that reads from Oracle and one that loads into Teradata. Sort of defeats the purpose of using DI tranformations in the first place though.

Re: Load Oracle table to teradata without extract transformation in sas di

LinusH — Sat, 18 Feb 2017 06:48:26 GMT

If you looking out to be an ETL developer in DI Studio you need to get training. You can't get trained by asking random questions on the communities.

BTW the answer is just omit it - a table loader will move the data for you. And that code will be generated for you. Bug filtering is not possible in this case. But it always comes down to what requirement/design is.

Re: Load Oracle table to teradata without extract transformation in sas di

Riteshdell — Wed, 22 Feb 2017 18:54:27 GMT

I am trained in Di studio, but faced this question in an interview, this is community where any person can ask any technical questions related to SAS, whatever the person is trained on SAS or not.

Don't tell me what I should ask or not.