|Papers Topic List|
|May 2012||Technical Paper: Optimize ETL for the Banking DDS
This paper discusses techniques to optimize ETL for the banking DDS to SAS solution data marts when the banking DDS is stored in a relational database other than SAS. These techniques can also be used as general methods for how SAS Data Integration Studio ETL jobs can be run in a database.
|March 2009||Change Data Capture and the Benefits to the Modern Enterprise Data Warehouse (PDF)
This paper investigates how the data warehouse has evolved from being a departmental reporting solution to a central repository of information that is key to active decision making for front-line users.
|March 2009||Dynamic Prompts Make Data Cascading Easy: Introducing New Features in SAS 9.2 Prompt Framework (PDF)
The prompt framework is available across all desktop and Web clients in the platform for SAS Business Analytics. A new feature in SAS 9.2, dynamic cascading prompts, enables users to create custom prompts that easily extract necessary information based on previously entered prompted values. This paper will highlight dynamic prompts and give an overview of new or enhanced features such as cascading prompts, relative date and time prompts, and range prompts.