Make Enquiry
  +44-740-880-6167 UK:    +44-740-880-6167       
+1-201-984-7795 USA:    +1-201-984-7795

Written by SRonline  
04 Jul 2013

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

ETL Fundamentals
- 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

Trouble Shooting
- Understand PowerCenter Log files
- View and look up error messages
- Correct mapping and workflow errors

PowerCenter Transformations, Tasks and Reusability
- Define list of PC Designer Transformations and Workflow Tasks
- Clarify Active vs. Passive Transformations
- 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

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

Using the Debugger
- Outline Debugger Interface
- Show creation of a break point
- Show Evaluate the Expression functionality
- Re-Execute mapping with different values

Sequence Generators, 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
- Build a Dates Lookup Cache for use in determining start and end dates of target records
-Utilize Event Wait, Event Timer and Email Tasks to wait for flat files and email users upon successful/failed load

Update Strategies, Routers and Overrides
- Build a mapping that uses Update Strategies and Routers to determine insert/update logic for a target
- Overrides will be used for incremental (daily) loading of the target

Sorter, Aggregator, Unconnected Lookups, Mapping Parameter/Variables and Mapplets /Worklets
- Define Sorter Transformation
- Detail Aggregator Transformation and Aggregate Functions
- Explain Unconnected Lookups and how they are called
- 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

Workflow Variables and Tasks
- Use PC workflow variables to pass information from one point in a workflow to another
- 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

Parameter Files and Command Tasks
- Use a Parameter file to make mappings and workflows more flexible by defining values for mapping variables, source files, database connections for sessions and workflow log files
- Command Tasks will be used to run scripts to rename and move files

Dynamic Lookups and Error Logging/Handling
- Use Dynamic Lookup, Router and Update Strategy in a mapping do a lookup on the target table and determine if the record should be an insert, update or logged to a file as an error
- Use PowerCenter Best Practices to create a mapping to trap fatal and non-fatal errors

More Lookup Functionality
- Create a Multiple Row Return Lookup, use Aggregators and Expressions to count the number of orders a Customer has as well as total the sales for that customer add those values to a target

Posted in Informatica 9  


Captcha: captcha

Learner Registration

Learner Registration


Publish a login form or anything you want to this position.


Publish a registration form or anything you want to this position.