BookmarkSubscribeRSS Feed
milts
Pyrite | Level 9

Hi,

I have no environment to try this out yet, but is it possible to use a Teradata table as a source on the Lookup node and then set the output table as a Teradata table still? Are there benefits or will it complicate processing and make it slower?

Thanks!

Milton

1 REPLY 1
LinusH
Tourmaline | Level 20

you definitely can, as long long you can have a libname assigned to the Teradata source.

About optimization, it's nearly impossible to have an opinion with this little information.

Probably will processing be slower than having it all happen in Teradata using pass-thru. So the question is, is there any functionality with the Look-up transform you need that can't be handled by a SQL join?

I think you should wait until you can get a hand on real data and try it in real life.

Data never sleeps

sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 979 views
  • 0 likes
  • 2 in conversation