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.