Tips and Tricks catalog consists of a serie half-day/full-day of knowledge transfer sessions in the SAS programming language, organized by a motivated SAS expert who combines theory and demonstrations to help you refresh your SAS skills or discover new techniques.
Designed for employees, these sessions are held at your office in one of your meeting rooms or remotly but for single employees only and is part of the SAS coaching service .
All sessions last 3 hours and can be conducted in French or English.
A Slowly Changing Dimension (SCD) is a dimension that stores and manages both current and historical data over time in a data warehouse. It is considered and implemented as one of the most critical ETL tasks in tracking the history of dimension records. Different SCD strategies could be implemented and this tips and tricks is focused on SCD1 where records are updated no history is kept and SCD2 where history is kept,
Indexes are special reference tables that the SAS engine can use to speed up data retrieval. Simply put, an index is a pointer to data in a table. In this tips and tricks we will discuss how you can create and use SAS indexes.
By continuing to browse the site you are agreeing to our use of cookies. Review our cookies information for more details.