舉報 
會員
Learning Informatica PowerCenter 10.x（Second Edition）
最新章節：
Summary
IfyouwishtodeployInformaticainenterpriseenvironmentsandbuildacareerindatawarehousing,thenthisbookisforyou.Whetheryouareasoftwaredeveloper/analyticprofessionalandarenewtoInformaticaoranexperienceduser,youwilllearnallthefeaturesofInformatica10.x.Abasicknowledgeofprogramminganddatawarehouseconceptsisessential.
目錄(294章)
倒序
- cover
- Title Page
- Second Edition
- Copyright
- Learning Informatica PowerCenter 10.x
- Second Edition
- Credits
- About the Author
- Acknowledgement
- About the Reviewer
- www.PacktPub.com
- Why subscribe?
- Customer Feedback
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Errata
- Piracy
- Questions
- Downloading and Extracting Informatica PowerCenter Software
- Downloading the latest version of Informatica PowerCenter - 10.1.0
- Extracting the downloaded files - preparing the installable
- Informatica installation - the prerequisites
- Beginning the installation - installing the server
- Configuring the domain and node
- Getting the graphical interface ready- client installation
- Summary
- Understanding Admin Console
- The Informatica architecture
- Domain
- Node
- Informatica services
- The service manager
- Repository
- Repository services
- Integration services
- Model repository service
- The Administration Console - configuration
- Repository creation - the centralized database for Informatica
- Creating the integration service - the path for flow of data
- Model Repository Service - a storage place for other developer tools
- Informatica users and authentications
- Repository Manager - the client configuration
- Summary
- Understanding Designer Screen and its Components
- Understanding Designer Interface
- Designer screen components
- Working with Sources
- Adding new Open Database Connectivity (ODBC) data source
- Working with relational database tables - the Import option
- Working with flat files - Import option
- Working with delimited files
- Working with fixed width files
- Working with Sources - the Create option
- Working with Targets
- Working with Target relational database tables - the Import option
- Working with Target Flat Files - the Import option
- Working with delimited files
- Working with fixed width Files
- Working with Target - the Create option
- Working with Target - the Copy or Drag-Drop option
- Creating Source Definition from Target structure
- Feel of data inside Repository - preview
- Previewing the source data - flat files
- Previewing the Source Data - relational tables
- Creating a Database Table
- Creating a mapping and using transformation features
- Summary
- The Lifeline of Informatica - Transformations
- Creating the transformation
- Mapping Designer
- Mapplet Designer
- Transformation Developer
- Expression transformation
- Ports in transformations
- Using the expression editor
- Aggregator transformation
- Using Group By
- Using Sorted Input
- Sorter transformation
- Filter transformation
- Router transformation
- Rank transformation
- Group by Ranking
- Rank Index
- Sequence Generator transformation
- Ports of Sequence Generator transformation
- Properties of Sequence Generator transformation
- Joiner transformation
- Master and Detail Pipeline
- Join condition
- Join type
- Normal join
- Full join
- Master Outer join
- Detail Outer join
- Union transformation
- Source Qualifier transformation
- Viewing default query
- Overriding default query
- Using the WHERE clause
- Joining Source Data
- Sorting the data
- Selecting distinct records
- Classification of transformations
- Active and Passive
- Connected and Unconnected
- Lookup transformation
- Creating the Lookup transformation
- Configuring the Lookup transformation
- Configuring the Lookup transformation
- Lookup ports
- Lookup query
- Unconnected Lookup transformation
- Lookup transformation properties
- Update Strategy transformation
- Normalizer transformation
- Configuring Normalizer transformation - ports
- Stored Procedure transformation
- Importing Stored Procedure transformation
- Creating Stored Procedure transformation
- Using Stored Procedure transformation in Mapping
- Connected Stored Procedure transformation
- Unconnected Stored Procedure transformation
- Transaction Control transformation
- Types of Lookup cache
- Building the Cache - Sequential or Concurrent
- Sequential cache
- Concurrent cache
- Persistent cache - the permanent one
- Sharing the cache - named or unnamed
- Sharing unnamed cache
- Sharing named cache
- Modifying cache - static or dynamic
- Static cache
- Dynamic cache
- Tracing level
- Summary
- Using the Designer Screen - Advanced Features
- Debug me please - the debugger
- Reuse me please - reusable transformation
- Using Transformation Developer
- Making an existing transformation reusable
- Mapplet
- Managing the constraints - the target load plan
- Avoid hardcoding - parameters and variables
- Comparing objects
- Summary
- Implementing SCD Using Designer Screen Wizards
- Types of SCD
- SCD1
- SCD2 - Version number
- SCD2 - FLAG
- SCD2 - Date range
- SCD3
- SCD1 - I hate history!
- SCD2 (version number) - I need my ancestors!
- SCD2 (flag) - flag the history
- SCD2 (date range) - marking the dates
- SCD3 - store something if not everything
- Summary
- Using the Workflow Manager Screen
- Using the Workflow Manager
- Creating a workflow
- Creating a workflow manually
- Creating a workflow automatically
- Adding a task to the workflow
- Adding tasks to the workflow directly
- Adding tasks to the workflow by task developer
- Adding tasks to the workflow by task developer
- Working with the Session task and basic properties
- Assigning the integration service to the workflow
- Deleting a workflow
- Trigger - starting a workflow
- Running a complete workflow
- Running a part of the workflow
- Running a task
- Working with Connection objects
- Creating a Connection object
- Configuring the Relational Database
- Summary
- Learning Various Tasks in Workflow Manager screen
- Working with tasks
- Configuring a task
- Session task
- Tabs of a session task
- Creating a Session Task
- Command task
- Creating a Command task
- Email Task
- Creating an Email Task
- Assignment Task
- Creating an Assignment Task
- Timer task
- Creating a Timer Task
- Control task
- Creating a Control task
- Decision task
- Creating a Decision task
- Event tasks - Event Wait and Event Raise
- Creating an Event (Wait/Raise) task
- Link task
- Creating a link task
- Worklets - Groups of tasks
- Creating a Worklet
- Summary
- Advanced Features of Workflow Manager Screen
- Schedulers
- File list - the indirect way
- Incremental Aggregation
- Parameter file - parameters and variables
- Defining session-level variables
- Defining workflow-level variables
- Defining mapping-level variables
- Creating a parameter file
- Mentioning the Parameter file at the workflow level
- Mentioning the Parameter file at the session level
- Summary
- Working with Workflow Monitor - Monitoring the code
- Using the Workflow Monitor
- Connecting the Workflow Manager Screen
- Opening previous workflow runs
- Running or recovering workflow or task
- Stopping or aborting the workflow or task
- Status of the workflow and tasks
- Viewing session log and workflow log
- Working with the workflow log
- Working with the session Log
- Viewing workflow run properties
- Viewing session run properties
- Task detail properties
- Source/target statistics properties
- Common Errors
- Summary
- The Deployment Phase - Using Repository Manager
- Using the Repository Manager
- Take me to the next stage - Deployment or Migration
- Export/Import
- Migrating from Designer
- Migrating from Repository Manager
- Copy/Paste
- Drag/Drop
- Summary
- Optimization - Performance Tuning
- Bottlenecks
- Finding the target bottleneck
- Using thread statistics
- Configuring the sample target load
- Eliminating the target bottleneck
- Minimizing target table deadlocks
- Dropping indexes and constraints
- Increasing the checkpoint interval
- Using an external loader
- Increasing the network packet size
- Using bulk load
- Finding the source bottleneck
- Using thread statistics
- Test mapping
- Using filter transformation
- Checking the database query
- Eliminating the source bottleneck
- Increasing the network packet size
- Optimizing the database query
- Finding the mapping bottleneck
- Using thread statistics
- Using filter transformation
- Eliminating the mapping bottleneck
- Using single pass mapping
- Avoiding data type conversions
- Unchecking unnecessary ports
- Processing numeric data
- Using operators instead of functions
- Using Decode in place of multiple IIF
- Tracing level
- Using variable ports
- Optimizing filter transformation
- Optimizing Aggregator transformation
- Optimizing joiner transformation
- Optimizing lookup transformation
- Eliminating the session bottleneck
- Optimizing the commit interval
- Buffer memory
- Performance data
- Eliminating the system bottleneck
- Working on partitioning
- Partitioning properties
- Partition points
- Number of partitions
- Partition types
- Pushdown optimization
- Summary 更新時間：2021-07-02 20:56:29
推薦閱讀
- PHP動態網站程序設計
- DB2 V9權威指南
- 數據結構和算法基礎（Java語言實現）
- 程序員面試筆試寶典
- Learning SAP Analytics Cloud
- Amazon S3 Cookbook
- Visual Basic學習手冊
- Learning FuelPHP for Effective PHP Development
- C#應用程序設計教程
- Express Web Application Development
- MongoDB，Express，Angular，and Node.js Fundamentals
- Java程序員面試筆試寶典（第2版）
- Android傳感器開發與智能設備案例實戰
- Learning VMware vSphere
- Java 9 Programming By Example
- Learning Nessus for Penetration Testing
- Deep Learning for Natural Language Processing
- Clojure for Finance
- PHP典型模塊與項目實戰大全
- Mastering Magento Theme Design
- Python量子計算實踐：基于Qiskit和IBM Quantum Experience平臺
- Java項目驅動開發教程
- 計算機教學研究與實踐：2017學術年會論文集
- 數據結構：C語言描述（融媒體版)
- Cadence Concept-HDL ＆ Allegro原理圖與電路板設計（第2版）
- Visual C++.NET(2008)典型案例
- Python核心編程從入門到開發實戰
- 孩子趣味學編程之Scratch篇
- 自己動手寫網絡爬蟲（修訂版）
- 玩轉Django 2.0
