首頁 > 計算機網(wǎng)絡(luò) >
編程語言與程序設(shè)計
> Learning Informatica PowerCenter 10.x（Second Edition）最新章節(jié)目錄
舉報 
會員
Learning Informatica PowerCenter 10.x（Second Edition）
最新章節(jié)：
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
推薦閱讀
- ASP.NET Core：Cloud-ready，Enterprise Web Application Development
- JavaScript前端開發(fā)模塊化教程
- Java EE 6 企業(yè)級應(yīng)用開發(fā)教程
- Rust編程：入門、實戰(zhàn)與進階
- Cross-platform Desktop Application Development：Electron，Node，NW.js，and React
- Mastering macOS Programming
- Mastering ServiceNow（Second Edition）
- TradeStation交易應(yīng)用實踐：量化方法構(gòu)建贏家策略（原書第2版）
- Node.js全程實例
- Internet of Things with ESP8266
- 打開Go語言之門：入門、實戰(zhàn)與進階
- Getting Started with Polymer
- 微課學人工智能Python編程
- Java EE 7 with GlassFish 4 Application Server
- Exploring SE for Android
- 算法秘籍
- The Applied Data Science Workshop
- Flink原理深入與編程實戰(zhàn)：Scala+Java（微課視頻版）
- 測試基地實訓指導
- PostGIS Cookbook
- OpenACC并行編程實戰(zhàn)
- SFML Game Development By Example
- Visual Basic數(shù)據(jù)庫開發(fā)全程指南
- Salesforce Platform App Builder Certification Handbook
- NuGet 2 Essentials
- 企業(yè)數(shù)字化轉(zhuǎn)型與工業(yè)4.0漸進之路：電子元器件行業(yè)視角
- Creating Development Environments with Vagrant（Second Edition）
- Mastering Adobe Captivate 8
- OpenShift在企業(yè)中的實踐：PaaS DevOps微服務(wù)
- ClickHouse入門、實戰(zhàn)與進階
