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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.