02-17-2017 06:29 PM
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.
Thanks in advance.
02-17-2017 06:55 PM
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.
02-18-2017 01:48 AM
02-22-2017 01:54 PM