When to use Extract transformation and loader transformation in SAS DI

[VVDR]

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.

[Rama_V · Accepted solution]

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.