Blistering ETL Performance Using the Intelligent, Dynamic and Parallel Capabilities of SAS

ETL from billion-record+ databases is a non-trivial task. By using the unique capabilities of SAS to analyze the database in advance and then dynamically generating parallel SAS jobs based on this interrogation, SAS can effectively performance-tune itself each run for maximum benefit. Get in, get out, get the results. The net effect is to get the fastest possible results with the minimum window of ETL load on the source system. Scalable, efficient, and easy to develop. An added benefit is the data visualization possible post-analysis and pre-ETL to aid data quality checks.

Provided by: SAS Institute Topic: Data Management Date Added: Mar 2010 Format: PDF

Download Now

Find By Topic