SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Hello, SAS DI STUDIO

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

Hello, SAS DI STUDIO

What is the difference between sas DI SQL JOIN & Lookup Transformation?


Accepted Solutions
Solution
‎08-09-2015 03:17 PM
SAS Employee
Posts: 75

Re: Hello, SAS DI STUDIO

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.

View solution in original post


All Replies
Solution
‎08-09-2015 03:17 PM
SAS Employee
Posts: 75

Re: Hello, SAS DI STUDIO

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.

Occasional Contributor
Posts: 15

Re: Hello, SAS DI STUDIO

Posted in reply to DaveR_SAS

Thank you DaveR

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 386 views
  • 0 likes
  • 2 in conversation