What is the difference between sas DI SQL JOIN & Lookup Transformation?
This DI Studio user guide topic includes a brief description of all transformations:
SAS(R) Data Integration Studio 4.901: User's Guide
If there is an example for that transformation, there is a link to the example. Here is the text about those two transformations:
LookUp -- Loads a target with columns taken from a source and from several lookup tables. For more information, see Loading a Fact Table Using Dimension Table Lookup.
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 Creating a Simple SQL Query.
This DI Studio user guide topic includes a brief description of all transformations:
SAS(R) Data Integration Studio 4.901: User's Guide
If there is an example for that transformation, there is a link to the example. Here is the text about those two transformations:
LookUp -- Loads a target with columns taken from a source and from several lookup tables. For more information, see Loading a Fact Table Using Dimension Table Lookup.
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 Creating a Simple SQL Query.
Thank you DaveR
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.