Data Management

SAS Data Integration Studio: Tips and Techniques for Implementing ELT

Date Added: Mar 2010
Format: PDF

Is one looking to improve performance of the data integration processes? One best practice is to stage data inside the database and direct SAS to do its data integration work inside the database. Extract, Load, and Transform (ELT) is an increasingly popular way to minimize data movement and gain efficiencies using the existing database management system. This paper explains how to enable ELT processing using the newest features of SAS Data Integration Studio 4.21 and SAS/ACCESS.