Informatica for Administrators培训

课程编码

informadmin

课程时长

14 小时 通常来说是2天,包括中间休息。

要求

  • Experience with SQL

Audience

  • System Administrators

课程概览

Informatica是一家软件公司,提供用于建立和维护ETL流程的产品。 ETL流程包括从源中提取数据,对其进行转换并将其加载到目标数据仓库中。

这种由讲师指导的实时培训(现场或远程)针对希望管理Informatica环境的系统管理员。

在培训结束时,参与者将能够:

  • 使用PowerCenter构建映射,任务和工作流。
  • 维护存储库迁移和外部版本控制系统。
  • 在元数据级别导入和/或导出。

课程形式

  • 互动式讲座和讨论。
  • 很多练习和练习。
  • 在现场实验室环境中动手实施。

课程自定义选项

  • 要请求此课程的定制培训,请与我们联系以安排。

Machine Translated

课程大纲

Introduction

Informatica and Data Warehouses

  • What are data warehouses?
  • Enterprise architecture vs centralized architecture
  • ODS vs OLTP vs OLAP

Informatica PowerCenter in Depth

  • Domain architecture
  • Nodes and node types

Informatica Admin Console

  • Creating services
  • Creating domains
  • Setting up services
  • Starting and stopping services
  • Creating web services
  • Exposing metadata and data
  • Configuring grids
  • Obtaining data and metadata

Security and IDQ Services

  • Setting up LDAP
  • Using IDQ MRS and IDQ DIS
  • Working with IDQ CMS and IDQ Analyst
  • Setting up OS profiles

PowerCenter Workflows and Versioning

  • Preparing the development environment for developers
  • Using transformations
  • Working with Mapplet
  • Using debugger
  • Working with monitor tools
  • Creating SQL commands for threading
  • Checking dependencies
  • Viewing history
  • Purging objects
  • Working with repositories

Deployment

  • Creating deployment groups
  • Migrating folder forms
  • Migrating single objects

Summary and Conclusion

客户评论

★★★★★
★★★★★

课程分类

相关课程

促销课程

订阅促销课程

为尊重您的隐私,我公司不会把您的邮箱地址提供给任何人。您可以享有优先权和随时取消订阅的权利。

我们的客户

is growing fast!

We are looking to expand our presence in China!

As a Business Development Manager you will:

  • expand business in China
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

该网站在其他国家/地区