下载  >  数据库  >  其它  > informatica powercenter 官方教程

informatica powercenter 官方教程 评分:

官方教程,两天初步掌握powercenter的使用。。。。。。。。。
icense.htmlhttp://www.libssh2.org,http:/slf4j.org/license.htmlhttp://www.sente.ch/software/opensourcelicense.htmlhttp://fusesource.com/downloads/license- agreements/fuse-message-broker-v-5-3-license-agreement;http:/antlr.org/license.htmlhttp:/aopalliance.sourceforge.net/;http://www.bouncycastle.org/licence.html http://www.jgraph.com/jgraphdownload.htmlhttp:/wwwjcraft.com/jsch/license.tt;http:/jotm.objectweb.org/bsdlicensehtmlhttp://www.w3.org/consortiUm/legal/ 2002/copyright-software-20021231;http://www.slf4j.org/license.htmlhttpi/nanoxml.sourceforge.net/orig/copyright.htmlhttp://wwwjson.org/license.htmlhttp:// forge.ow2.org/projects/javaservice/,http://wwwpostgresql.org/about/licence.htmlhttp://www.sqlite.org!copyright.htmlhttp://www.tcl.tk/software/tcltk/license.htmlhttp:// www.jaxen.org/faq.htmlhttp://www.jdomorg/docs/faq.htmlhttp://www.slf4jorg/license.htmlhttp://www.iodbc.org/dataspace/iodbc/wiki/iodbc/license;http:/i www.keplerproject.org/md5/icense.htmlhttp://www.toedter.com/en/jcalendar/license.html;http://www.edankert.com/bounce/index.htmlhttp:/www.net-snmp.org/about/ licensehtmlhttp://www.openmdx.org/#faq;http://www.php.nev/license/301.txthttp://srp.stanfordeduilicense.txthttp://www.schneier.com/blowfish.htmlhttp:// www.jmock.org/license.htmlhttp://xsomjavanethttp://benalman.com/about/icense/;httpsgithub.com/createjs/eAseljs/blob/master/sRclEaseljs/display/bitmap.js: http://www.h2database.com/htmi/icense.html#summary;http:/jsoncpp.sourceforge.net/license;http:/jdbc.postgresql.org/license.htmlhttp.:// protobuf.googlecode.com/svn/trunksrc/google/protobuf/descriptor.proto;https:/github.com/rantav/hector/blob/master/license;http://web.mitedu/kerberos/Krb5 current/doc/mitk5license.htmlhttp://jibx.sourceforge.net/ibx-license.htmlandhttps:/github.com/lyokato/libgeohash/blob/master/license ThisproductincludessoftwarelicensedundertheAcademicFreeLicense(http://www.opensource.orghlicenSes/afl-3.0.php),theCommonDevelopmentandDistribution icense(http://www.opensource.org/licenses/cddl1-php)theCommonPublicLicense(http://www.opensource.org/licenses/cpl1.0-php),theSunBinaryCodeLicense AgreementSupplementalLicenseTerms,theBsdLicense(http://www.opensource.org/licenses/bsd-license.php),thenewBsdLicense(http.//opensource.org icenses/bsd-3-clause),theMitLicense(http://www.opensource.org/licenses/mit-license.php),theArtisticLicense(http://www.opensource.org/licenseslartistic license-1.0)andtheInitialDevelopersPublicLicenseVersion1.0(http:/www.firebirdsql.org/en/initial-developer-s-public-license-version-1-0/) This product includes software copyright 2003-2006 Joe WaInes, 2006-2007 XStream Committers. All rights reserved. Permissions and limitations regarding th softwarearesubjecttotermsavailableathttp:/ixstream.codehaus.org/license.htmlThisproductincludessoftwaredevelopedbytheIndianaUniversityExtreMe!Lab Forfurtherinformationpleasevisithttp://www.extreme.indianaedu This product includes software Copyright (c) 2013 Frank Balluffi and Markus Moeller. All rights reserved Permissions and limitations regarding this software are subject to terms of the mit licens This Software is protected by U.s. Patent Numbers5,794,246:6014670;6,016501;6029,178;6,032,158:6,035,307;6,044,374;6,092,086;6,208,990:6,339775; 6,640,226:6,789,096;6,823,373;6.850,947;6895,471:7,117,215;7,162,643;7,243,110;7,254,590:7,281,001;7,421,458;7,496,588;7,523,121:7,584,422; 7,676,516:7,720,842;7,721270;7774,791;8,065,266:8,150,803;8,166,048;8,166,071;8,200,622;8,224,873;8,271,477;8,327,419;8,386,435:8,392,460; 8,453, 159: 8, 458, 230; and RE44, 478, International Patents and other Patents pending DISCLAIMER: Informatica Corporation provides this documentation "as is" without warranty of any kind, either express or implied, including but not limited to, the.n Is implied warranties of noninfringement, merchantability, or use for a particular purpose. Informatica Corporation does not warrant that this software or documentation is error free. The information provided in this software or documentation may include technical inaccuracies or typographical errors the information in this software and documentation is subject to change at any time without notice NOTICES This Informatica product(the"Software")includes certain drivers(the"Data Direct Drivers")from Data Direct Technologies, an operating company of Progress Software orporation (DataDirect")which are subject to the following terms and conditions: 1. THE DATADIRECT DRIVERS ARE PROVIDED AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING BUT NOT LIMITED TO. THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT INCIDENTAL, SPECIAL, CONSEQUENTIAL OR OTHER DAMAGES ARISING OUT OF THE USE OF THE ODBC DRIVERS, WHETHER OR NO CT 2. IN NO EVENT WILL DATADIRECT OR ITS THIRD PARTY SUPPLIERS BE LIABLE TO THE END-USER CUSTOMER FOR ANY DIRECT, INDIRE INFORMED OF THE POSSIBILITIES OF DAMAGES IN ADVANCE. THESE LIMITATIONS APPLY TO ALL CAUSES OF ACTION INCLUDING, WITHOUT LIMITATION BREACH OF CONTRACT BREACH OF WARRANTY NEGLIGENCE STRICT LIABILITY MISREPRESENTATION AND OTHER TORTS Part Number: PC-GEs-96100-000-0001 Table of contents Preface Informatica rest tica My Support porta Informatica documentation Informatica web site Informatica How-To Library Informatica Knowledge Bas Informatica Support You Tube Channel Informatica Marketpl Informatica∨ elocity Informatica Global Customer Support Chapter 1: Product Overview Introduction So Targets Informatica domain Service Manager. Application Service Power Center Repository. Informatica administrator Domain Page Security Tab Domain configuration PowerCenter client PowerCenter Designer. Mapping Architect for Visio Repository Manager. orkflow Manager flow monit 12 Power Center Repository service 13 Power Center Integration Service 14 Web services hub 14 Data analyz 15 Data Analyzer Components 15 Metadata manager Metadata Manager components 16 Chapter 2: Before You Begin Before You Begin Overview 18 Table of contents Getting started Jsing Informatica administrator in the tutorial 19 Using the PowerCenter Client in the tutorial 19 Informatica Domain and the PowerCenter Repository Domain Administrator PowerCenter Repository and User Account Power Center Source and Target. .21 Chapter 3: Tutorial Lesson Creating Users and Groups 23 Logging In to Informatica Administrator .23 Creating a Group. 24 C g a Us Creating a Folder in the PowerCenter Repository Folder permissions 26 Connecting to the Repository Creating a Fold 27 Creating Source Tables Chapter 4: Tutorial Lesson 2. 00001 Creating Source Detinitions Viewing Source Definitions Target Definitions and Target Tables 34 Creating Target Definitions 34 Creating Target Tables 36 Chapter 5: Tutorial Lesson 3 38 ng a Pass-Through Mapping Creating a Mapping Connecting Transformations Creating Sessions and Workflows 41 Configuring Database Connections in the Workflow Manager g a Reusable Session Creating a Workflow. Running and Monitoring Workflows 47 Opening the Workflow Monitor Running the Workflow 48 Previewing Data Chapter 6: Tutorial Lesson 4 Using Transformations g a Target Definition and Target Table of contents Creating a Target Definition Creating a Target Table 54 Creating a Mapping with Aggregate Values Creating a Mapping with T_ ITEM SUMMARY Creating an Aggregator Transformation Creating an expression transformation Creating a Lookup Transformation Connecting the Target ....61 Designer Tips Using the Overview Window 62 Arranging transformations Creating a Session and Workflow Creating the Session Creating the Workflo 63 Running the workflow iewing the Logs 65 Chapter 7: Tutorial Lesson 5 ,,,,66 Creating a Mapping with Fact and Dimension Tables Creating Targets 67 Creating the Mapping Creating a filter transformation Creating a Sequence Generator Transformation 70 Creating a Stored Procedure Transformation Completing the Mapping 73 Creating a Workflow 74 Creating the workflow 75 Adding a Non-Reusable Session 75 Defining a Link Condition 75 Running the Workflow 77 Chapter 8: Tutorial Lesson 6 sing XML Fil Creating the XML Source Importing the XML Source 80 Editing the XML Definition 82 Creating the Target Definition Creating a Mapping with XML Sources and Targets Creating an Expression Transformation Creating router Transformations Completing the Mapp Creating a Workflow. 93 Table of contents Appendix A: Naming Conventions Suggested Naming Conventions Naming convention 95 Appendix B: Glossary. Index ■1首盖B 1 1圆面1■ 115 iv Table of contents Preface PowerCenter Getting Started is written for the developers and software engineers who are responsible for implementing a data warehouse. It provides a tutorial to help first-time users learn how to use Power Center PowerCenter Getting Started assumes you have knowledge of your operating systems, relational database concepts, and the database engines, flat files, or mainframe systems in your environment. The guide also assumes you are familiar with the interface requirements for your supporting applications Informatica resources Informatica My Support Portal As an Informatica customer, you can access the Informatica My Support Portal at http://mysupport.informatica.com The site contains product information, user group information, newsletters, access to the Informatica customer support case management system(ATLAS), the Informatica How-To Library, the Informatica Knowledge Base, Informatica Product Documentation, and access to the Informatica user community Informatica documentation The Informatica Documentation team takes every effort to create accurate, usable documentation. If you have questions, comments, or ideas about this documentation, contact the Informatica Documentation team throughemailatinfadocumentation@informatica.com.Wewilluseyourfeedbacktoimproveour documentation. Let us know if we can contact you regarding your comments The documentation team updates documentation as needed. to get the latest documentation for your productnavigatetoProductDocumentationfromhttp:/mysupport.informatica.com Informatica web site YoucanaccesstheInformaticacorporatewebsiteathttp:/www.informatica.comThesitecontains information about Informatica, its background, upcoming events, and sales offices. You will also find product and partner information The services area of the site includes important information about technical support, training and education, and implementation services Informatica How-To Library As an Informatica customer, you can access the Informatica How-To Library at http:/mysupport.informaticacomTheHow-toLibraryisacollectionofresourcestohelpyoulearnmore about Informatica products and features. It includes articles and interactive demonstrations that provide solutions to common problems, compare features and behaviors, and guide you through performing specific real-world tasks Informatica Knowledge base As an Informatica customer, you can access the Informatica Knowledge Base at http://mysupport.informaticacomUsetheKnowledgeBasetosearchfordocumentedsolutionstoknown technical issues about Informatica products. You can also find answers to frequently asked questions, technical white papers, and technical tips. If you have questions, comments, or ideas about the Knowledge Base,contacttheInformaticaKnowledgeBaseteamthroughemailatKBFeedback@informatica.com Informatica Support You Tube Channel YoucanaccesstheInformaticaSupportyoUTubechannelathttp://www.youtube.com/user/nfasupport.The Informatica Support You Tube channel includes videos about solutions that guide you through performing specific tasks. If you have questions, comments, or ideas about the Informatica Support You tube channel contacttheSupportYouTubeteamthroughemailatsupportvideos@informatica.comorsendatweetto @INFASupport Informatica Marketplace The Informatica Marketplace is a forum where developers and partners can share solutions that augment, extend, or enhance data integration implementations. By leveraging any of the hundreds of solutions available on the Marketplace, you can improve your productivity and speed up time to implementation on yourprojectsYoucanaccessInformaticaMarketplaceathttp://www.informaticamarketplace.com Informatica Velocity YoucanaccessInformaticaVelocityathttp://mysupport.informaticacomDevelopedfromthereal-world experience of hundreds of data management projects, Informatica Velocity represents the collective knowledge of our consultants who have worked with organizations from around the world to plan, develop deploy, and maintain successful data management solutions. If you have questions, comments, or ideas aboutiNformaticaVelocitycontactInformaticaProfessionalServicesatips@informatica.com Informatica Global Customer Support You can contact a Customer Support Center by telephone or through the Online Support Online Support requires a user name and password. You can request a user name and password at http://mysupport.informatica.com The telephone numbers for Informatica Global Customer Support are available from the Informatica web site athttp://wwwinformatica.com/us/services-and-training/support-services/global-support-centers/. Preface CHAPTER 1 Product overview This chapter includes the following topics Introduction Informatica domain 4 PowerCenter Repository, 5 Informatica administrator. 6 Domain Confiquration, 7 PowerCenter Client. 8 PowerCenter Repository Service, 13 PowerCenter Integration Service, 14 Web services hub. 14 Data Analyzer, 15 Metadata Manager, 16 Introduction Power Center provides an environment that allows you to load data into a centralized location, such as a data warehouse or operational data store(ODS). You can extract data from multiple sources, transform the data according to business logic you build in the client application, and load the transformed data into file and relational targets Power Center also provides the ability to view and analyze business information and browse and analyze metadata from disparate metadata repositories Power Center includes the following components Informatica domain. The Informatica domain is the primary unit for management and administration within PowerCenter. The Service Manager runs on an Informatica domain The Service Manager supports the domain and the application services Application services represent server-based functionality. The domain supports powercenter and Informatica application services. Powercenter application services include the PowerCenter Repository Service, PowerCenter Integration Service, Web Services Hub, and SAP BW Service. Informatica Services include the Data Integration Service, Model Repository Service and the Analyst Service Powercenter repository. The Powercenter repository resides in a relational database. the repository database tables contain the instructions required to extract, transform, and load data

...展开详情
2018-01-19 上传 大小:4.13MB
举报 收藏 (2)
分享

评论 下载该资源后可以进行评论 共2条

qq_28047939 密码是什么啊
2019-03-21
回复
jsmasaww Informatica从入门到项目实际开发视频教程 网盘地址:https://pan.baidu.com/s/1TVEkcst-4Fz10UTMBcrZvQ 提取码: hrrp 备用地址(腾讯微云):https://share.weiyun.com/5CxMBb1 密码:ty5aif
2018-11-27
回复
informatica基础完整版

详细的informatica工具使用教程,主要组件的使用和 Workflow 的串行、并行的 设置及 Workflow 控制等内容。

立即下载
informatica官方中文教程

超级详细的informatca power center的中文官方教程,包括: 安装和配置指南 数据归档指南 designer指南 powercenter connect for JMS 资料库指南 转换指南 转换语言参考 故障排除智囊 XML用户指南 工作流管理指南

立即下载
Informatica_PowerCenter_Designer指南.pdf

名称:Designer指南 版本:informatica powercenter 7.1.1适用(官方出版) 文件类型:PDF PDF页数:476 描述:介绍informatica powercenter Designer的使用方法

立即下载
Informatica PowerCenter入门指南.pdf

Informatica PowerCenter入门指南, 介绍的环境安装,配置的细节.

立即下载
Informatica优化(经验总结)

近来由于工作需要,使用informatica powercenter,对powercenter优化有几点浅微见解: 1、为平衡性能,在数据库可接受范围内尽量在数据库中进行数据排序,即在source qualifier里sql语句中进行排序; 2、抽取数据时只抽取需要字段,尽量减少输入输出端口,在其他组件也类似,一旦字段不需要输出,取消输出端口的选中状态; 3、数据要尽量早过滤,减少mapping过程中携带的数据量。。。。

立即下载
Informatica_PowerCenter_9.6.1 官方中文文档

Informatica_PowerCenter_9.6.1 官方中文文档

立即下载
powercenter学习笔记(自己整理)精

使用版本为8.6.1 数字类型转换为字符类型(数字类型高精度问题) 批量修改mapping中目标表表名 查询Expression 中的数据 根据文件夹初始化序列,初始为1 MAPPING中修改设置变量,只会在下一次启动MAPPING时有效,他不能影响当前SESSSION中的值 Update Strategy Expression 使用DD_UPDATE失效问题 元数据库检索ETL异常错误SQL

立即下载