When to use Extract transformation and loader transformation in SAS DI

VVDR — Fri, 28 Aug 2020 03:00:11 GMT

Hi All,

In SAS DI studio, I am extraction/loading data from 4 datasets and creating one new dataset.

Now, I am confused with "Extract transformation" and "loader transformation", which one to use and what is the difference. After selecting which one to use I am going to use "Join transformation" to filter some records based on the conditions. Please advise.

Thanks.

Re: When to use Extract transformation and loader transformation in SAS DI

Rama_V — Mon, 31 Aug 2020 01:45:59 GMT

Extract and Table Loader both can be used to create final Metadata Registered non work Table.

Extract just does Select statement with work table.

Table loader has additional feature which will help to maintain target table properly, for example like dropping indexes and constraints or truncate tables(especially helps in database permission maintenance) instead recreating it completely. While loading into Database Tables it also has additional options to process faster like bulk loading etc

DI studio looks at the Table Loader as Final step and provides the Target tables information in Basic properties.

My best practice is to use Extract for intermediate steps for minor changes in data or when I want to break down the code in smaller steps, and saving Table Loader for final step.

Hope this helps for start. For more refer to documentation.

topic When to use Extract transformation and loader transformation in SAS DI in SAS Data Management

When to use Extract transformation and loader transformation in SAS DI

Re: When to use Extract transformation and loader transformation in SAS DI