SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Load Oracle table to teradata without extract transformation in sas di

Reply
Contributor
Posts: 68

Load Oracle table to teradata without extract transformation in sas di

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.

 

Super User
Posts: 3,256

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

Posted in reply to Ritesh_dellvostro

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.

Super User
Posts: 5,431

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

Posted in reply to Ritesh_dellvostro
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.
Data never sleeps
Contributor
Posts: 68

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

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.
Ask a Question
Discussion stats
  • 3 replies
  • 233 views
  • 0 likes
  • 3 in conversation