Using SAS® Studio Engineer Steps in SAS® Studio Flows
This course shows how to use Table Loader steps in SAS Studio flows to perform Insert and Update operations for database tables, including how to implement slowly changing dimensions. This course also covers how to execute SAS Intelligent Decisioning decisions with a SAS Studio flow step. Learn How To Use SAS Studio flow steps to perform a variety of operations to load source data into database tables. Configure the load steps to either replace existing data in the target database table with the data in source tables or perform Insert and Update operations based on a key value. Implement slowly changing dimensions in database tables so that historical records are retained when records in the dimension tables are updated. Use SAS Studio flows to send data to decisions created by SAS Intelligent Decisioning and capture the decision results in a table within the flow. Who Should Attend Data engineers who want to use SAS Studio flows to design data management operations Prerequisites Before attending this course, you should have completed the SAS Programming 1: Essentials course and the Building SAS Studio Flows in SAS Viya course or have equivalent knowledge. SAS Products Covered SAS Studio Course Outline SAS Studio Flows and the SAS Studio Engineer StepsOverview of SAS Studio flows. SAS Studio Engineer flow steps. Tips and tricks for Using the virtual lab to complete practices.The Table Loader StepTable loader capabilities and specifications. Using the Table Loader step for existing target tables. Using the Table Loader step when the target table does not yet exist.The Merge Table StepMerge table capabilities and specifications.Using the Merge Table step.The Implement SCD StepKey concepts for slowly changing dimensions. Adding the SCD generated key to the fact table. Implement SCD capabilities and specifications.Using the Implement SCD step.The Execute Decisions StepWhat decisions are and how they are implemented in SAS Studio flows. Exploring decisions and using the Execute Decisions step.
|