topic Re: Hello, SAS DI STUDIO in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Hello-SAS-DI-STUDIO/m-p/195145#M4189 <HTML><HEAD></HEAD><BODY><P>This DI Studio user guide topic includes a brief description of all transformations:</P><P><A href="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/viewer.htm#n0geesvp950nken1tetx8ffwoxkt.htm" title="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/viewer.htm#n0geesvp950nken1tetx8ffwoxkt.htm">SAS(R) Data Integration Studio 4.901: User's Guide</A></P><P></P><P>If there is an example for that transformation, there is a link to the example. Here is the text about those two transformations:</P><P></P><P>LookUp -- Loads a target with columns taken from a source and from several lookup tables. For more information, see <SPAN class="xis-xrefSee"><SPAN class="xis-xrefText"></SPAN><A href="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/p0pcm98e10xf2rn1ag4w0w0qwybp.htm" title="“Loading a Fact Table Using Dimension Table Lookup”">Loading a Fact Table Using Dimension Table Lookup</A></SPAN>.</P><P></P><P>Join -- Selects multiple sets of rows from one or more sources and writes each set of rows to a single target. Typically used to merge two or more sources into one target. Can also be used to merge two or more copies of a single source. For more information, see <SPAN class="xis-xrefSee"><SPAN class="xis-xrefText"></SPAN><A href="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/n05jvz0yb145v6n1misog11qb9vk.htm" title="“Creating a Simple SQL Query”">Creating a Simple SQL Query</A></SPAN>.</P></BODY></HTML> Sun, 09 Aug 2015 19:17:44 GMT DaveR_SAS 2015-08-09T19:17:44Z Hello, SAS DI STUDIO https://communities.sas.com/t5/SAS-Data-Management/Hello-SAS-DI-STUDIO/m-p/195144#M4188 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 12pt;">What is the difference between sas DI SQL JOIN &amp; Lookup Transformation?</SPAN></P></BODY></HTML> Sun, 09 Aug 2015 13:16:26 GMT https://communities.sas.com/t5/SAS-Data-Management/Hello-SAS-DI-STUDIO/m-p/195144#M4188 vishu 2015-08-09T13:16:26Z Re: Hello, SAS DI STUDIO https://communities.sas.com/t5/SAS-Data-Management/Hello-SAS-DI-STUDIO/m-p/195145#M4189 <HTML><HEAD></HEAD><BODY><P>This DI Studio user guide topic includes a brief description of all transformations:</P><P><A href="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/viewer.htm#n0geesvp950nken1tetx8ffwoxkt.htm" title="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/viewer.htm#n0geesvp950nken1tetx8ffwoxkt.htm">SAS(R) Data Integration Studio 4.901: User's Guide</A></P><P></P><P>If there is an example for that transformation, there is a link to the example. Here is the text about those two transformations:</P><P></P><P>LookUp -- Loads a target with columns taken from a source and from several lookup tables. For more information, see <SPAN class="xis-xrefSee"><SPAN class="xis-xrefText"></SPAN><A href="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/p0pcm98e10xf2rn1ag4w0w0qwybp.htm" title="“Loading a Fact Table Using Dimension Table Lookup”">Loading a Fact Table Using Dimension Table Lookup</A></SPAN>.</P><P></P><P>Join -- Selects multiple sets of rows from one or more sources and writes each set of rows to a single target. Typically used to merge two or more sources into one target. Can also be used to merge two or more copies of a single source. For more information, see <SPAN class="xis-xrefSee"><SPAN class="xis-xrefText"></SPAN><A href="http://support.sas.com/documentation/cdl/en/etlug/68225/HTML/default/n05jvz0yb145v6n1misog11qb9vk.htm" title="“Creating a Simple SQL Query”">Creating a Simple SQL Query</A></SPAN>.</P></BODY></HTML> Sun, 09 Aug 2015 19:17:44 GMT https://communities.sas.com/t5/SAS-Data-Management/Hello-SAS-DI-STUDIO/m-p/195145#M4189 DaveR_SAS 2015-08-09T19:17:44Z Re: Hello, SAS DI STUDIO https://communities.sas.com/t5/SAS-Data-Management/Hello-SAS-DI-STUDIO/m-p/195146#M4190 <HTML><HEAD></HEAD><BODY><P>Thank you DaveR</P></BODY></HTML> Mon, 10 Aug 2015 05:52:38 GMT https://communities.sas.com/t5/SAS-Data-Management/Hello-SAS-DI-STUDIO/m-p/195146#M4190 vishu 2015-08-10T05:52:38Z