舉報 
會員
Learning Informatica PowerCenter 10.x（Second Edition）
Rahul Malewar 著
更新時間：2021-07-02 20:56:29
開會員，本書免費讀 >
最新章節：
Summary
IfyouwishtodeployInformaticainenterpriseenvironmentsandbuildacareerindatawarehousing,thenthisbookisforyou.Whetheryouareasoftwaredeveloper/analyticprofessionalandarenewtoInformaticaoranexperienceduser,youwilllearnallthefeaturesofInformatica10.x.Abasicknowledgeofprogramminganddatawarehouseconceptsisessential.
最新章節
- Summary
- Pushdown optimization
- Partition types
- Number of partitions
- Partition points
- Partitioning properties
品牌：中圖公司
上架時間：2021-07-02 18:34:36
出版社：Packt Publishing
本書數字版權由中圖公司提供，并由其授權上海閱文信息技術有限公司制作發行
- Summary 更新時間：2021-07-02 20:56:29
- Pushdown optimization
- Partition types
- Number of partitions
- Partition points
- Partitioning properties
- Working on partitioning
- Eliminating the system bottleneck
- Performance data
- Buffer memory
- Optimizing the commit interval
- Eliminating the session bottleneck
- Optimizing lookup transformation
- Optimizing joiner transformation
- Optimizing Aggregator transformation
- Optimizing filter transformation
- Using variable ports
- Tracing level
- Using Decode in place of multiple IIF
- Using operators instead of functions
- Processing numeric data
- Unchecking unnecessary ports
- Avoiding data type conversions
- Using single pass mapping
- Eliminating the mapping bottleneck
- Using filter transformation
- Using thread statistics
- Finding the mapping bottleneck
- Optimizing the database query
- Increasing the network packet size
- Eliminating the source bottleneck
- Checking the database query
- Using filter transformation
- Test mapping
- Using thread statistics
- Finding the source bottleneck
- Using bulk load
- Increasing the network packet size
- Using an external loader
- Increasing the checkpoint interval
- Dropping indexes and constraints
- Minimizing target table deadlocks
- Eliminating the target bottleneck
- Configuring the sample target load
- Using thread statistics
- Finding the target bottleneck
- Bottlenecks
- Optimization - Performance Tuning
- Summary
- Drag/Drop
- Copy/Paste
- Migrating from Repository Manager
- Migrating from Designer
- Export/Import
- Take me to the next stage - Deployment or Migration
- Using the Repository Manager
- The Deployment Phase - Using Repository Manager
- Summary
- Common Errors
- Source/target statistics properties
- Task detail properties
- Viewing session run properties
- Viewing workflow run properties
- Working with the session Log
- Working with the workflow log
- Viewing session log and workflow log
- Status of the workflow and tasks
- Stopping or aborting the workflow or task
- Running or recovering workflow or task
- Opening previous workflow runs
- Connecting the Workflow Manager Screen
- Using the Workflow Monitor
- Working with Workflow Monitor - Monitoring the code
- Summary
- Mentioning the Parameter file at the session level
- Mentioning the Parameter file at the workflow level
- Creating a parameter file
- Defining mapping-level variables
- Defining workflow-level variables
- Defining session-level variables
- Parameter file - parameters and variables
- Incremental Aggregation
- File list - the indirect way
- Schedulers
- Advanced Features of Workflow Manager Screen
- Summary
- Creating a Worklet
- Worklets - Groups of tasks
- Creating a link task
- Link task
- Creating an Event (Wait/Raise) task
- Event tasks - Event Wait and Event Raise
- Creating a Decision task
- Decision task
- Creating a Control task
- Control task
- Creating a Timer Task
- Timer task
- Creating an Assignment Task
- Assignment Task
- Creating an Email Task
- Email Task
- Creating a Command task
- Command task
- Creating a Session Task
- Tabs of a session task
- Session task
- Configuring a task
- Working with tasks
- Learning Various Tasks in Workflow Manager screen
- Summary
- Configuring the Relational Database
- Creating a Connection object
- Working with Connection objects
- Running a task
- Running a part of the workflow
- Running a complete workflow
- Trigger - starting a workflow
- Deleting a workflow
- Assigning the integration service to the workflow
- Working with the Session task and basic properties
- Adding tasks to the workflow by task developer
- Adding tasks to the workflow by task developer
- Adding tasks to the workflow directly
- Adding a task to the workflow
- Creating a workflow automatically
- Creating a workflow manually
- Creating a workflow
- Using the Workflow Manager
- Using the Workflow Manager Screen
- Summary
- SCD3 - store something if not everything
- SCD2 (date range) - marking the dates
- SCD2 (flag) - flag the history
- SCD2 (version number) - I need my ancestors!
- SCD1 - I hate history!
- SCD3
- SCD2 - Date range
- SCD2 - FLAG
- SCD2 - Version number
- SCD1
- Types of SCD
- Implementing SCD Using Designer Screen Wizards
- Summary
- Comparing objects
- Avoid hardcoding - parameters and variables
- Managing the constraints - the target load plan
- Mapplet
- Making an existing transformation reusable
- Using Transformation Developer
- Reuse me please - reusable transformation
- Debug me please - the debugger
- Using the Designer Screen - Advanced Features
- Summary
- Tracing level
- Dynamic cache
- Static cache
- Modifying cache - static or dynamic
- Sharing named cache
- Sharing unnamed cache
- Sharing the cache - named or unnamed
- Persistent cache - the permanent one
- Concurrent cache
- Sequential cache
- Building the Cache - Sequential or Concurrent
- Types of Lookup cache
- Transaction Control transformation
- Unconnected Stored Procedure transformation
- Connected Stored Procedure transformation
- Using Stored Procedure transformation in Mapping
- Creating Stored Procedure transformation
- Importing Stored Procedure transformation
- Stored Procedure transformation
- Configuring Normalizer transformation - ports
- Normalizer transformation
- Update Strategy transformation
- Lookup transformation properties
- Unconnected Lookup transformation
- Lookup query
- Lookup ports
- Configuring the Lookup transformation
- Configuring the Lookup transformation
- Creating the Lookup transformation
- Lookup transformation
- Connected and Unconnected
- Active and Passive
- Classification of transformations
- Selecting distinct records
- Sorting the data
- Joining Source Data
- Using the WHERE clause
- Overriding default query
- Viewing default query
- Source Qualifier transformation
- Union transformation
- Detail Outer join
- Master Outer join
- Full join
- Normal join
- Join type
- Join condition
- Master and Detail Pipeline
- Joiner transformation
- Properties of Sequence Generator transformation
- Ports of Sequence Generator transformation
- Sequence Generator transformation
- Rank Index
- Group by Ranking
- Rank transformation
- Router transformation
- Filter transformation
- Sorter transformation
- Using Sorted Input
- Using Group By
- Aggregator transformation
- Using the expression editor
- Ports in transformations
- Expression transformation
- Transformation Developer
- Mapplet Designer
- Mapping Designer
- Creating the transformation
- The Lifeline of Informatica - Transformations
- Summary
- Creating a mapping and using transformation features
- Creating a Database Table
- Previewing the Source Data - relational tables
- Previewing the source data - flat files
- Feel of data inside Repository - preview
- Creating Source Definition from Target structure
- Working with Target - the Copy or Drag-Drop option
- Working with Target - the Create option
- Working with fixed width Files
- Working with delimited files
- Working with Target Flat Files - the Import option
- Working with Target relational database tables - the Import option
- Working with Targets
- Working with Sources - the Create option
- Working with fixed width files
- Working with delimited files
- Working with flat files - Import option
- Working with relational database tables - the Import option
- Adding new Open Database Connectivity (ODBC) data source
- Working with Sources
- Designer screen components
- Understanding Designer Interface
- Understanding Designer Screen and its Components
- Summary
- Repository Manager - the client configuration
- Informatica users and authentications
- Model Repository Service - a storage place for other developer tools
- Creating the integration service - the path for flow of data
- Repository creation - the centralized database for Informatica
- The Administration Console - configuration
- Model repository service
- Integration services
- Repository services
- Repository
- The service manager
- Informatica services
- Node
- Domain
- The Informatica architecture
- Understanding Admin Console
- Summary
- Getting the graphical interface ready- client installation
- Configuring the domain and node
- Beginning the installation - installing the server
- Informatica installation - the prerequisites
- Extracting the downloaded files - preparing the installable
- Downloading the latest version of Informatica PowerCenter - 10.1.0
- Downloading and Extracting Informatica PowerCenter Software
- Questions
- Piracy
- Errata
- Reader feedback
- Conventions
- Who this book is for
- What you need for this book
- What this book covers
- Preface
- Customer Feedback
- Why subscribe?
- www.PacktPub.com
- About the Reviewer
- Acknowledgement
- About the Author
- Credits
- Second Edition
- Learning Informatica PowerCenter 10.x
- Copyright
- Second Edition
- Title Page
- cover
- 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
