Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

INFORMATICA TRAINING BY INDUSTRY EXPER

No Reviews Yet

St Thomas Mount, Chennai

Course ID: 11845

St Thomas Mount, Chennai

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

Bigems is a new generation IT Training organization headquartered at Chennai offering The most
comprehensive and in-depth industry ready training solutions to enterprises and individuals across a wide
range of platforms and technologies. From its inception, Teknowledge s core business has been providing
high quality; industry endorsed training programs on the cutting edge technologies.
The focus is on design, development and implementation of new, existing or turnaround Companies. Our
team of consultants is world-leading providers in solutions that help organizations of all sizes to optimize
and streamline their operation and cost

Topics Covered

Author: Babjee
Informatica Course Content
Pre request: RDBMS Concepts and working knowledge with any database
Day 1
Agenda
Introduction data warehouse concepts and data warehouse techniques, about star schema ,
snowflack schemas, life cycle of data warehouse etc
• PowerCenter 8.6 Architecture
• Installation and Configuration
o Overview
o Installation - Windows
o Repository Server Setup - Windows
o PowerCenter Server Configuration (Windows)
• Repository Architecture
o Repository Server Features
o Repository Agents
o Repository Types
• Repository Server Administration Console
o Repository Tasks
o Backup and Restore
o Activity Log
• Repository Manager
o User Interface
o Menus
o Security
• Exporting/Importing Objects
• Troubleshooting
o Error Messages
o Error Logs
• data Integration Concepts
o Data Integration
o Mapping and Transformations
o Tasks and Workflows
o Metadata
• PowerCenter Components and User Interface
o PowerCenter Architecture
o PowerCenter Client Tools
o Lab - Using the Designer and Workflow Manager
Author: Babjee
Day 2
• Source Qualifier
o Source Qualifier Transformation
o Source Qualifier Joins
o Source Pipelines
• Expression, Filter, File Lists and Workflow Scheduler
o Expression Editor
o Filter Transformation
o File Lists
o Workflow Scheduler
o Lab - Load the Customer Staging Table
• Joins, Features and Techniques I
o Joiner Transformation
• Lookups and Reusable Transformations
o Lookup Transformation
o Reusable Transformations
• Debugger
o Debugging Mappings
• Sequence Generator
o Sequence Generator Transformation
• Lookup Caching, More Features and Techniques
o Lookup Caching
o II
Day 3
• Sorter, Aggregator and Self-Join
o Sorter Transformation
o Aggregator Transformation
o Active and Passive Transformations
o Data Concatenation
o Self-Join
• Router, Update Strategy and Overrides
o Router Transformation
o Update Strategy Transformation
o Expression Default Values
o Source Qualifier Override
o Target Override
o Session Task Mapping Overrides
• Dynamic Lookup and Error Logging
o Dynamic Lookup
o Error Logging
o Lab - Load Customer Dimension Table
• Unconnected Lookup, Parameters and Variables
o Unconnected Lookup Transformation
o System Variables
o Mapping Parameters and Variables
• Mapplets
o Mapplets

Day 4
Author: Babjee
• Mapping Design
o Designing Mappings
o Workshop
• Workflow Variables and Tasks
o Link Conditions
o Workflow Variables
o Assignment Task
o Decision Task
o Email Task
• More Tasks and Reusability
o Event Raise Task
o Event Wait Task
o Command Task
o Reusable Tasks
o Reusable Session Task
o Reusable Session Configuration
o PMCMD Utility
• Worklets and More Tasks
o Worklets
o Timer Task
o Control Task
• Workflow Design
o Designing Workflows
o Workshop (Optional)

• Performance Tuning
o Performance Tuning Overview
o Server Architecture
o Measuring Performance Internal to Informatica
o Establishing Baselines Internal to Informatica
o Identifying Bottlenecks
o Mapping Optimization
o Session Optimization
• Mapping Techniques
o Mapping Specification Documents
o Stored Procedure
o Mapping Parameters and Variables
o Self Join
o Transaction Control Transformation
o Data Driven Aggregation
o Incremental Aggregation
o Unconnected Lookup Techniques
o Dynamic Lookup Techniques
• Workflow Techniques
o Workflow Alerts
o Advanced Command Task and Parameter File Creation
• Data Error Handling
o Introduction
o Data Error Handling with Transaction Control

Who should attend

WORKING PEOPLES , FRESHERS

Pre-requisites

BASIC SQL KNOWLEDGE

What you need to bring

NOTE BOOK

Key Takeaways

DAILY CLASS TRANSCRIPT

Date and Time

Not decided yet.

About the Trainer

5 Avg Rating

3 Reviews

2 Students

1 Courses

Babjee has more than 12 years of IT experience out of which 7+ years in Data warehousing and Business
Intelligence toolset. Independent consultant for various clients handling large DW&BI projects. He is
conducted may corporate training in informatica cognos, business objects, oracle to clients like wipro, cts,
Ness solution, delloit and many more He is heading DW&BI training and project development divisions in
Bigems.

Reviews

No reviews currently Be the First to Review

Discussions

Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Informatica Training Post your requirement now

Enquire

Submit your enquiry for INFORMATICA TRAINING BY INDUSTRY EXPER

Please enter valid question or comment

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With BI-Gems Technologies

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at support@urbanpro.com for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more