loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for INFORMATICA TRAINING BY INDUSTRY EXPER

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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

Share

course photo

INFORMATICA TRAINING BY INDUSTRY EXPER

St Thomas Mount, Chennai

10,000

No Reviews Yet
0 Interested

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
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer

BABJEE

B.E


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.
Seats Left-

Students Interested 0

Course Id: 11845