|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/informatica-tutorial-beginner-to-expert-level/
课程评论：没有评论
课程名称：Informatica教程：从初学者到专家水平 课程概述：Informatica Power Center数据集成工具在过去十年中始终位于Gartner魔力象限的顶端，具备较高的上线率，相较于其他现有的ETL工具，表现优异。Informatica Power Center支持数据提取、转换和加载（ETL）过程的所有步骤。它能够连接多种技术，包括传统系统、主机、大型企业资源规划（ERP）、SAP、TIBCO、HP VERTICA到大数据等第三方产品。 该课程将帮助您熟悉Informatica Power Center 10.x/9.6x版本的使用，涵盖创建、执行、管理、监控和调度ETL流程的所有方面，并了解其在数据挖掘和企业数据仓库设置中的应用。Informatica Power Center提供用户友好的图形用户界面，利用简单的拖放功能构建数据抽取、转换和加载的工作流，便于用户理解和使用。 课程将揭示Informatica 10x/9x的架构，基于面向服务架构（SOA）的设计，处理数据提取、执行转换和加载数据到目标系统的操作。它能够通过ODBC源、插件和扩展与主要数据源（如主机、大数据、传统关系数据库、NoSQL等）进行高效通讯，并根据需求在不同数据源之间移动和转换数据。该工具能够有效处理大量数据，相比于专门的手动编程（如PL/SQL程序、Java、Perl等），资源消耗更低。 课程内容全面，从数据仓库概念、ETL开发人员的角色与职责、Informatica Power Center 10x/9.x的安装与配置，到详细的转换解释及实例、性能调优技巧、常见面试问题、每个模块的小测和测验，以及动手作业，深入讲解数据仓库服务、集成服务及其他基本管理活动等。 此课程适合希望提升自己在数据集成方面能力的学习者，通过课程，您将获得全面的理论知识与实践经验，为今后的职业发展打下坚实基础。
Informatica Power Center Data Integration tool is the top in the Gartner's magic quadrant for the past ten years with high GO LIVE rate compared to any other existing ETL tools in the market. Informatica Power Center tool supports all the steps of Extraction, Transformation and Load process/life cycle. There are lot of other (third party) products which are offered and created around the Power Center's ability to connect to different technologies ranging from Legacy systems, Mainframes to CRM, SAP, TIBCO, HP VERTICA to BIG DATA. Informatica Power Center Developer course, will introduce you to work with the Power Center version 10.x/9.6x to create, execute, as well as administer, monitor and schedule ETL processes and understand how these are used in data mining operations and enterprise data warehouse setup. Informatica Power Center is an easy to use GUI based tool. It has a simple visual interface which is easy to understand and use. All the components are designed to be used by a simple drag and drop feature for different objects like source, targets, transformations, mapplets, mappings, sessions, worklets and workflows which contribute to the design process flow of the data extraction, transformation and load. Once the objects are integrated into a package called as workflow, it can be scheduled to run as and when required with rich features to accommodate all the possibilities of a business requirement. The architecture of Informatica 10x/9x is created based on the SOA (Service Oriented Architecture) which takes care of the data fetch, execution of the transformation and load the data into the target systems in the desired formats like Relational, Flat File, XML, WSDL, PDF, Word (Structured, Semi-Structured, Un-Structured). Informatica Power Center 10x/9x has the ability to communicate via ODBC sources/plugins/extensions with all major data sources like Mainframe, Big Data, traditional RDBMS (Oracle, SQL Server, Teradata, Netezza, Informix, DB2 etc), NoSQL (Mongo DB, Cassandra etc) Flat Files, XML, TIBCO, WSDL (Via web services) SAP, Salesforce etc) and move/transform data between them based on the need. The tool's ability to fetch/transform and load huge volumes of data in a very effective way, with less resource consumption is better than hand coded programs written for specific data movement using PL/SQL procedures, Java, Perl and other languages. The course covers all topics starting from Data warehouse concepts, Roles and Responsibilities of an ETL developer, Installation & Configuration of Informatica Power Center 10x/9.X, in detailed explanation of transformations with practical examples, performance tuning tips for each transformation (clearly shown and explained), usually asked interview questions, quizzes for each section and assignments for your hands on and in-depth explanation of the Repository Service, Integration Service and other basic Administration Activities.
