Informatica 9.X Level 1 and Level 2 Training

Level 1 Course Agenda 1.An Overview of Informatica PowerCenter 9  Overview of PowerCenter covering areas such as the Architecture, Terminology, Tools GUI, Mappings, Transformations, Sessions, Workflows and Workflow Monitor 2. ETL Fundamentals How to create:       Flat file and relational Sources using the Source Analyzer Flat file and relational Targets using the Target Developer Mappings using the Mapping Designer Workflows using the Workflow Designer Monitor the workflow using the Workflow Monitor Preview Target Data using the PowerCenter Designer 3. Trouble Shooting Understand PowerCenter Log files Use PC log files to:   View and look up error messages Correct mapping and workflow errors 4. PowerCenter Transformations, Tasks and Reusability     Define list of PC Designer Transformations and Workflow Tasks Clarify Active vs. Passive Transformations Use the Expression Transformation and Editor in a mapping which applies a file list to load multiple flat files into a stage table utilizing expression and filter transformations to format and screen erroneous customer data. Use Reusable Designer Transformations to apply same formatting logic to Employee records 5. Joins and Link Conditions      Define Joins Clarify Heterogeneous vs Homogeneous Joins Use a Joiner Transformation to join relational and flat file sources Use the Source Qualify to join two relational sources Make use of Link Conditions to execute one session when the first finishes successfully. 6. Using the Debugger     Outline Debugger Interface Show creation of a break point Show Evaluate the Expression™ functionality Re-Execute mapping with different values Unconnected Lookups.       Define Sorter Transformation Detail Aggregator Transformation and Aggregate Functions Explain Unconnected Lookups and how they are called. Overrides will be used for incremental (daily) loading of the target. update or logged to a file as an error. database connections for sessions and workflow log files. Routers and Overrides  Build a mapping that uses Update Strategies and Routers to determine insert/update logic for a target. Describe Mapping Parameters/Variables and initialization priority Outline Mappets and Worklets Use these Transformations to create a mapping which loads records from warehouse Dimension tables to a Fact table. Build a Dates Lookup Cache for use in determining start and end dates of target records Utilize Event Wait. Update Strategies. 8. Aggregator. 10. Lookups and Caching        Define the Sequence Generator Define the Lookup Transformation What are the different types of Lookups? Clarify Lookup Caching Use a Flat File Lookup to add data to a relational target. Command Tasks will be used to run scripts to rename and move files. Workflow Variables and Tasks    Use PC workflow variables to pass information from one point in a workflow to another. Use PowerCenter Best Practices to create a mapping to trap fatal and non-fatal errors. Event Timer and Email Tasks to wait for flat files and email users upon successful/failed load. Use an Assignment task to establish the value of a workflow variable within a workflow Use a decision task to set criteria by which the workflow will decide which execution branch to follow 11. Mapping Parameter/Variables and Mapplets /Worklets. More Lookup Functionality . Sorter. Parameter Files and Command Tasks   Use a Parameter file to make mappings and workflows more flexible by defining values for mapping variables.7. Dynamic Lookups and Error Logging/Handling   Use Dynamic Lookup. source files. Router and Update Strategy in a mapping do a lookup on the target table and determine if the record should be an insert. 12. 13. Sequence Generators. 9. 14. Describe PowerCenter's optional and built-in high availability features. 4. 2. 7. Create a Multiple Row Return Lookup. 15. Recover tasks and workflows that stop. abort or terminate. use Aggregators and Expressions to count the number of orders a Customer has as well as total the sales for that customer. Stored Procedure & SQL Transformations   Describe the use of the Stored Procedure transformation in a mapping or mapplet. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the workflow Level 2 Course Agenda 1. . Describe control when data is committed to disk or the target database. Pivoting Data  Describe the use of the normalizer and aggregator transformation to normalize and de-normalize date. Describe & implement advanced functions. Add those values to a target. Workflow & Task Recovery    Describe workflow and task recovery with and without the high availability option. Explain and use PowerCenter's built-in recovery capabilities. User-Defined & Advanced Functions   Describe User Defined Function to Create Entity Types. Transaction Control Transform   Describe the use of the transaction control transformation for data-driven transaction control. The workshop will provide Velocity Best Practices documents that can be used to determine the correct logic for the mapping. 6. 5. PowerCenter Overview   Describe the Components of the PowerCenter 9 Architecture and define key terms. Mapping Design Workshop  Business requirements details will be provided so that the student can design and build their own mapping necessary to load a Promotions Aggregate table. Transaction Processing   Describe Source based & Target based transaction controls with and without high availability option. Workflow Design Workshop  Business requirements details will be provided so that the student can design and build their own workflow necessary to load all staging tables in a single workflow. Describe the use of PowerCenter constraint-based loading in databases with referential integrity constraints. Describe the uses of the SQL Transform. 3. Describe types of target bottlenecks: database. Describe 3 alternatives to the update-else-insert scenario. Describe external loader effects on targe bottlenecks. Describe thread utilization to identify a target bottleneck. Design error handling strategies appropriate for the intended purpose of a workflow. Describe Types of source bottlenecks: database. Describe how transaction control impacts performance. network. Command Line Utilities   Use pmcmd to start. 12. 10. Explain the performance implications of the stored procedure vs. disk & PowerCenter. back-up and EBF migration of a unit or work. Describe how partitioning affects the DTM buffer pool. network. concurrent & file list. Performance Tuning: Caching & Memory Optimization   Describe data caching & RAM memory optimization techniques to improve session performance Describe DTM buffer pool optimization. disk & PowerCenter. Use pmrep for object export. Describe tune the line sequential buffer. Performance Tuning: Mapping Design    Explain types of data type conversion: port-to-port.  Explain the user-designed recovery techniques. 11. Performance Tuning: Methodology            Describe Performance counters. the SQL transformation. Describe 3 options for merging partitions: sequential. expression-to-port and explicit. Describe thread utilization to identify a source bottleneck. Describe busy percentages & how they help in bottleneck isolation. restart and recover workflows. 9. Performance Tuning: Partitions    Describe how pipelines & partitions affect performance. Identify which transformations increase or decrease the number of rows. 8. mass validation. Describe thread utilization to identify a transformation bottleneck. . object import.