Load Oracle table to teradata without extract transformation in sas di

[Riteshdell]

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.

[SASKiwi]

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.

[LinusH]

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.

[Riteshdell]

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.