Informatica PowerCenter 9.6.1 Transformation Guide (English) PC 961 En
User Manual:
Open the PDF directly: View PDF
Page Count: 493 [warning: Documents this large are best viewed by clicking the View PDF Link!]
- Table of Contents
- Preface
- Chapter 1: Working with Transformations
- Chapter 2: Aggregator Transformation
- Chapter 3: Custom Transformation
- Chapter 4: Custom Transformation Functions
- Custom Transformation Functions Overview
- Function Reference
- Working with Rows
- Generated Functions
- API Functions
- Set Data Access Mode Function
- Navigation Functions
- Property Functions
- Rebind Datatype Functions
- Data Handling Functions (Row-Based Mode)
- Set Pass-Through Port Function
- Output Notification Function
- Data Boundary Output Notification Function
- Error Functions
- Session Log Message Functions
- Increment Error Count Function
- Is Terminated Function
- Blocking Functions
- Pointer Functions
- Change String Mode Function
- Set Data Code Page Function
- Row Strategy Functions (Row-Based Mode)
- Change Default Row Strategy Function
- Array-Based API Functions
- Chapter 5: Data Masking Transformation
- Data Masking Transformation Overview
- Masking Properties
- Key Masking
- Substitution Masking
- Dependent Masking
- Random Masking
- Applying Masking Rules
- Expression Masking
- Special Mask Formats
- Social Security Number Masking
- Credit Card Number Masking
- Phone Number Masking
- Email Address Masking
- Social Insurance Number Masking
- IP Address Masking
- URL Address Masking
- Default Value File
- Data Masking Transformation Session Properties
- Rules and Guidelines for Data Masking Transformations
- Chapter 6: Data Masking Examples
- Chapter 7: Expression Transformation
- Chapter 8: External Procedure Transformation
- External Procedure Transformation Overview
- Configuring External Procedure Transformation Properties
- Developing COM Procedures
- Developing Informatica External Procedures
- Distributing External Procedures
- Development Notes
- COM Datatypes
- Row-Level Procedures
- Return Values from Procedures
- Exceptions in Procedure Calls
- Memory Management for Procedures
- Wrapper Classes for Pre-Existing C/C++ Libraries or VB Functions
- Generating Error and Tracing Messages
- Unconnected External Procedure Transformations
- Initializing COM and Informatica Modules
- Other Files Distributed and Used in TX
- Service Process Variables in Initialization Properties
- External Procedure Interfaces
- Chapter 9: Filter Transformation
- Chapter 10: HTTP Transformation
- Chapter 11: Identity Resolution Transformation
- Chapter 12: Java Transformation
- Chapter 13: Java Transformation API Reference
- Chapter 14: Java Expressions
- Chapter 15: Java Transformation Example
- Chapter 16: Joiner Transformation
- Chapter 17: Lookup Transformation
- Lookup Transformation Overview
- Lookup Source Types
- Connected and Unconnected Lookups
- Lookup Components
- Lookup Properties
- Lookup Query
- Lookup Condition
- Lookup Caches
- Return Multiple Rows
- Configuring Unconnected Lookup Transformations
- Database Deadlock Resilience
- Creating a Lookup Transformation
- Tips for Lookup Transformations
- Chapter 18: Lookup Caches
- Chapter 19: Dynamic Lookup Cache
- Dynamic Lookup Cache Overview
- Dynamic Lookup Properties
- Lookup Transformation Values
- Dynamic Lookup Cache Updates
- Mappings with Dynamic Lookups
- Conditional Dynamic Cache Updates
- Dynamic Cache Update with Expression Results
- Synchronizing Cache with the Lookup Source
- Dynamic Lookup Cache Example
- Rules and Guidelines for Dynamic Lookup Caches
- Chapter 20: Normalizer Transformation
- Chapter 21: Rank Transformation
- Chapter 22: Router Transformation
- Chapter 23: Sequence Generator Transformation
- Chapter 24: Sorter Transformation
- Chapter 25: Source Qualifier Transformation
- Source Qualifier Transformation Overview
- Source Qualifier Transformation Properties
- Default Query
- Joining Source Data
- Adding an SQL Query
- Entering a User-Defined Join
- Outer Join Support
- Entering a Source Filter
- Using Sorted Ports
- Select Distinct
- Adding Pre- and Post-Session SQL Commands
- Creating a Source Qualifier Transformation
- Troubleshooting Source Qualifier Transformations
- Chapter 26: SQL Transformation
- Chapter 27: Using the SQL Transformation in a Mapping
- Chapter 28: Stored Procedure Transformation
- Stored Procedure Transformation Overview
- Using a Stored Procedure in a Mapping
- Writing a Stored Procedure
- Creating a Stored Procedure Transformation
- Configuring a Connected Transformation
- Configuring an Unconnected Transformation
- Error Handling
- Supported Databases
- Expression Rules
- Tips for Stored Procedure Transformations
- Troubleshooting Stored Procedure Transformations
- Chapter 29: Transaction Control Transformation
- Chapter 30: Union Transformation
- Chapter 31: Unstructured Data Transformation
- Unstructured Data Transformation Overview
- Configuring the Unstructured Data Option
- Data Transformation Service Types
- Unstructured Data Transformation Components
- Unstructured Data Transformation Ports
- Unstructured Data Transformation Service Names
- Relational Hierarchies
- Mappings
- Creating an Unstructured Data Transformation
- Chapter 32: Update Strategy Transformation
- Chapter 33: XML Transformations
- Index