|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/etl-framework-for-data-warehouse-environments/
课程评论：没有评论
课程名称：数据仓库环境中的ETL框架 课程概述：本课程提供了一种高层次的方法，用于在典型的数据仓库环境中实施ETL框架。课程内容适用于需要设计和实施ETL解决方案的新应用程序，该解决方案具有高度可重用性，涵盖不同的数据加载策略、错误/异常处理、审计平衡和控制处理、作业调度的基本知识以及可重启性功能。同时，本课程也适用于现有的ETL实现，要求将该框架嵌入现有环境、作业和业务需求中，必要时甚至可能从头开始重新设计整个映射、映射组件及工作流（ETL作业），这在考虑到高可重用性和改进设计标准的益处时，绝对是一个明智的选择。 本课程结合了设计和实施完整ETL解决方案的标准和实用方法，详细介绍了指导方针、标准、开发人员/架构师检查清单以及可重用代码的好处。此外，本课程还教授了在实施ETL解决方案时应遵循的最佳实践和标准。尽管本课程是基于Informatica 10x和Oracle 11g的ETL设计原则和解决方案，但这些内容可以应用于市场上任何ETL工具，如IBM DataStage、Pentaho、Talend、Ab-initio等。课程还将提供多个可重用代码包、检查清单，以及入门UNIX基本命令和Shell脚本所需的材料。
This course provides a high level approach to implement an ETL framework in any typical Data Warehouse environments. The practical approaches can be used for a new application that needs to design and implement ETL solution which is highly reusable with different data loading strategies, error/exception handling, audit balance and control handling, a bit of job scheduling and the restartability features and also to any existing ETL implementations. For existing implementations this framework needs to be embedded into the existing environment, jobs and business requirements and it might also go to a level of redesigning the whole mapping/mapplets and the workflows (ETL jobs) from scratch, which is definitely a good decision considering the benefits for the environment with high re-usability and improved design standards. This course is a combination of standard and practical approaches of designing and implementing a complete ETL solution which details the guidelines, standards, developer/architect checklist and the benefits of the reusable code. And, this course also teaches you the Best practices and standards to be followed in implementing ETL solution. Though this course, covers the ETL design principles and solutions based on Informatica 10x, Oracle 11g, these can be incorporated to any of the ETL tools in the market like IBM DataStage, Pentaho, Talend, Ab-intio etc. Multiple reusable code bundles from the marketplace, checklists and the material required to get started on UNIX for basic commands and Shell Scripting will be provided.
