Analytics: Advanced Data Warehouse Developer - LVC
|
What you will learn The required pre-requisites for this course are: Analytics: Overview (Siebel 7.7) Analytics: Data Warehouse Developer (Siebel 7.7) This course is part of a comprehensive training program intended for members of Siebel Analytics implementation teams. The goal of the program is to enable participants to perform the tasks required to successfully complete a Siebel Analytics deployment. This course is one of three advanced role-based Analytics courses. This course provides advanced training in topics related to the tasks performed by an Analytics Data Warehouse Developer. It is intended for individuals on the implementation team whose major role is to configure, customize, and administer the Siebel Relationship Management Warehouse (SRMW), Informatica, and Data Warehouse Application Console (DAC) for Siebel Analytics. This course provides instructor-led training on advanced topics and concepts beyond those covered in the base course, Analytics: Data Warehouse Developer (Siebel 7.7). The course presents material in five sections. In the SRMW Configuration section, students learn advanced SRMW configuration concepts, including advanced change capture concepts, change capture deletes, auxiliary change capture process, and slowly changing dimensions. In the DAC Configuration section, students learn advanced DAC configuration topics, including populating a custom set of date dimension values, using command line option to access the DAC server, and configuring ETL to selectively refresh the SRMW. In the ETL Migration section, students explore the processes used to migrate Informatica mappings and workflows, Informatica repository, and DAC repository. In the Siebel Analytics Applications Upgrade section, students learn about the various bridge applications that are available to provide compatibility between different versions of Siebel Analytics Applications and Siebel CRM applications. In the Performance Tuning section, students learn to employ best practices for configuring SRMW. This course is appropriate for Analytics 7.7 and 7.8.Live Virtual Class (LVC) Access Policy:
Students attending LVC events should enroll at least two working days in advance of the event to ensure adequate time to download student materials and confirm their system setup. To learn more about the system and setup requirements for participating in a Live Virtual Class, please click here. |
| Audience Functional Implementer Technical Consultant |
| Prerequisites Analytics: Overview (Siebel 7.7) Analytics: Data Warehouse Developer (Siebel 7.7) |
| Course Objectives To enable students to apply advanced techniques when configuring, customizing, and administering Siebel SRMW, Informatica, and DAC for Siebel Analytics |
| Course Topics Exploring the Change Capture Process Capturing and Applying Deletes Building Auxiliary Change Capture Building Slowly Changing Dimensions Using Command Line to Access the DAC Server Populating a Custom Set of Date Dimension Values Configuring ETL to Selectively Refresh the SRMW Migrating ETL Mappings and Workflows Migrating Informatica Repository Migrating DAC Repository Reviewing the Siebel Analytics Bridge Applications Employing Best Practices for Configuring the SRMW Configuring the SRMW for Global Deployments |
| Related Courses Analytics: Advanced Application Developer Analytics: Advanced Server Architect Analytics: Application Developer (Siebel 7.7) Analytics: Overview (Siebel 7.7) Analytics: Server Architect (Siebel 7.7) Analytics: Data Warehouse Developer (Siebel 7.7) |