H2K Home HOME
Contact H2K CONTACT

Courses Offered


Follow us on

Twitter    Facebook    LinkedIn     Youtube

Demo Schedules

New Demo Schedules

Demo sessions for the month of April 2010




MAKE A PAYMENT

Enter the Amount to Pay & Click the button

$.00


TESTIMONIALS


Thank you for all the support to our team and project. Your training helped  a lot to move forward quickly. Thanks a lot

Manager, McKesson










Greetings!
SAP class was simply excellent! Thank you! You were just too good!!!
I'm glad I attended your training classes. It seems pretty simple and  interesting now. I want to start practicing on it. After I'm done with, may be I'll ask for any help I need. Your teaching techniques are easy to understand, help to build more confidence to work on real time projects.

Regards,
Mani










Hi H2K Infosys Team,
Thank you for providing me training. After I took training from you and worked on few projects as per your guidance and Now I settled as software QA analyst. When I joined your training, I am new to IT field, at present I am IT pro and  helping my co workers who have been working from a while. I owe a lot to H2K Infosys. I pray god every day to grow H2K Infosys. Good Luck.

Mathew










To be frank I was very satisfied with your training for what I have paid, And Thats why I keep telling my friends about your training center ,when they ask me ,I will do so in the present and in future also. Since I liked your training class I tell my friends and I want them also to be benefited like me. And one more thing is that u give us chances to attend the classes n number of times which is hard to find in other training centers, through that way we learn different things and concepts, through different teaching staffs. At times u also gives importance to our decisions and conveniences which is really great. Whoever asks me for sure I will say your training center only at present and in future also. I have heard many of training centers through my friends and I feel urs is good in some way or the other. Good work.

Thank you,
Sridevi










Again I'm really pleased with the course, told someone in my company how great it is; and now she's interested in taking the course as well.

Thank you,
Lak








COURSES > Informatica

Informatica

Course is customized to individual need. This will help to expand your skill sets and give confidence to take new challenging role.





DETAILS

CLASS-1
Introduction and Architectural Overview Extraction, Transformation and loading process PowerCenter 8.x architecture
Basic Element of Data Warehouse
Source System
Data Staging Area
Facts & Dimensions
Data warehouse and Latency
Data Integration
Repository Topics
Repository Server and agent
Repository maintenance
Repository Server Administration Console
Security, Repository, privileges and folder permissions
Objects sharing, searching, and locking
Metadata extensions
Lab 1- Create a Folder

CLASS-2
Source Object Definitions
Source types
Source properties
Lab 2- Analyze Source Data
Target Object Definitions
Target types
Target properties
Lab 3- Import Target Schema
Transformation Concepts
Transformation types and views
Transformation features and ports
Expression transformation
Informatica functions and data types

CLASS-3
Mappings
Mapping components
Source Qualifier transformation
Pre SQL and Post SQL
Mapping validation
Data flow rules
Objects export and import
Lab 4 –Create a Mapping

CLASS-4
Workflows
Workflow Tools
Workflow Structure and configuration
Workflow Tasks
Workflow Design and properties
Session Tasks
Session Task properties
Session components
Transformation overrides
Session partitions

CLASS-5
Workflow Monitoring
Workflow Monitor views
Monitoring a Server
Actions initiated from the workflow Monitor
Truncating Monitor Logs
Lab 6 – Start and Monitor a Workflow

CLASS-6
Debugger
Debugger features
Debugger windows
Tips for using the Debugger
Lab 7 –The Debugger
Filter transformation
Filter properties
Lab 8- Flat File Wizard and Filter

CLASS-7
Aggregator transformation
Aggregation function and expression
Aggregator properties
Using sorted data
Incremental Aggregation
Joiner transformation
Joiner types
Joiner conditions and properties
Joiner usage and Nested joins
Lab 9 – Heterogeneous join

CLASS-8
Sorter transformation
Sorter properties
Sorter limitations
Lab 10 – Sorter
Lookup transformation
Lookup principles
Lookup properties
Lookup techniques
Lab 11 – Basic Lookup

CLASS-9
Target options
Row type indicators
Row loading operations
Constraint- based loading
Rejected row handling options
Lab 12 – Deleting Rows
Update Strategy transformation
Update strategy expressions
Smart aggregation
Refresh strategies

CLASS-10
Lab 13 – Data Driven Inserts and Rejects
Router transformation
Using a router
Router groups
Lab 14 – Router
Mapping Parameters and variables
Mapping parameters and variables usage
System Variables
Variables functions
Conditional Parameters and Variables
Mapping parameter and variable usage
System Variables
Variable functions

CLASS-11
Conditional Lookups
Usage and techniques
Advantage
Functionality
Lab 15 – Straight Load
Lab 16 – Conditional Lookups

CLASS-12
Heterogeneous Targets
Heterogeneous target types
Target type conversions and limitations
Lab 17 – Heterogeneous Targets
Mapplets
Functionality and Advantages
Mapplet types and structure
Mapplet limitations
Lab 18 – Mapplets

CLASS-13
Reusable transformations
Advantages
Limitations
Promoting and copying transformations
Lab 19 – Reusable transformations
Sequence Generator transformation
Using a sequence Generator
Sequence Generator properties
Dynamic Lookup
Dynamic lookup theory
Usage and functionality
Advantages
Lab 20 – Dynamic Lookup

CLASS-14
Concurrent and sequential Workflows
Concurrent Workflows
Sequential Workflows
Stopping, Starting and suspending tasks and workflows
Lab 21 – Sequential Workflow
Additional Transformations
Rank transformation
Normalizer transformation
Customer Transformation
Transformation Control transformation
Error Handling
Overview of Error Handling Topics
Velocity Error Handling Strategies

CLASS-15
Performance Tuning
Overview of System Environment
Identifying Bottlenecks
Lab 22 – Error handling fatal and non Fatal
Mapping Variables
Introduction to Mapping Variable and Parameters
Creating Mapping Variables and Updating Variables
Creating Parameter File and associating file to a Session
Lab 26 - Override Mapping Variable with Parameter Files
Lab 27 – Dynamically Updating a Source Qualifier with Mapping Variable
Reusable Workflow Tasks
WorkLets
Worklets Limitation
Lab 28 – Create Worklets using Tasks
Command Line Interface ( PMCMD)
Overview of PMCMD and functions

CLASS-16
Informatica 8.X overview

CLASS-17
New Features of Informatica 8.x

CLASS-18
Informatica Assignment 1

CLASS-19
Informatica Assignment 2

CLASS-20
Informatica Assignment 3