topic Re: Lookup Node with Teradata table in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Lookup-Node-with-Teradata-table/m-p/81537#M746 <HTML><HEAD></HEAD><BODY><P>you definitely can, as long long you can have a libname assigned to the Teradata source.</P><P>About optimization, it's nearly impossible to have an opinion with this little information.</P><P></P><P>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?</P><P></P><P>I think you should wait until you can get a hand on real data and try it in real life.</P></BODY></HTML> Wed, 13 Jun 2012 10:17:31 GMT LinusH 2012-06-13T10:17:31Z Lookup Node with Teradata table https://communities.sas.com/t5/SAS-Data-Management/Lookup-Node-with-Teradata-table/m-p/81536#M745 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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?</P><P></P><P>Thanks!</P><P>Milton</P></BODY></HTML> Wed, 13 Jun 2012 03:45:38 GMT https://communities.sas.com/t5/SAS-Data-Management/Lookup-Node-with-Teradata-table/m-p/81536#M745 milts 2012-06-13T03:45:38Z Re: Lookup Node with Teradata table https://communities.sas.com/t5/SAS-Data-Management/Lookup-Node-with-Teradata-table/m-p/81537#M746 <HTML><HEAD></HEAD><BODY><P>you definitely can, as long long you can have a libname assigned to the Teradata source.</P><P>About optimization, it's nearly impossible to have an opinion with this little information.</P><P></P><P>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?</P><P></P><P>I think you should wait until you can get a hand on real data and try it in real life.</P></BODY></HTML> Wed, 13 Jun 2012 10:17:31 GMT https://communities.sas.com/t5/SAS-Data-Management/Lookup-Node-with-Teradata-table/m-p/81537#M746 LinusH 2012-06-13T10:17:31Z