Signup as a Tutor

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

Informatica PowerCenter With Administrator

No Reviews Yet

Course type: Online Instructor led Course

Platform: GoToMeeting/TeamViewer/Hangout/Skype

Course ID: 40364

Course type: Online Instructor led Course

Platform: GoToMeeting/TeamViewer/Hangout/Skype

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

Informatica PowerCenter:
========================
This is 40+ hours of course to Informatica Data Quality 10.x through lecture and hands-on exercises (50% theory and 50% hands include admin console & admin task).


The course is designed for Developers who are new to Informatica PowerCenter.


Informatica PowerCenter is a thick client for ETL – Extract, Transform and Load from any data to any data format.


PowerCenter- Prerequisites:
===========================
Basic SQL knowledge like select, insert, delete, update, join, Aggregator etc.


Basic Datawarehousing knowledge


 


Informatica PowerCenter Course Details:


===========================


 


Data Warehousing Concepts:



  • Introduction to Data Warehouse

  • What is Data Warehouse and why we need Data Warehouse

  • Dimensions / Fact Tables

  • Different Types of Dimensions and Facts

  • Slowly Changing Dimensions and its types

  • Dimensional modeling

  • Star schema/Snowflake schema

  • Data Mart vs Data Warehouse


ETL & Informatica



  • ETL Overview

  • Informatica Overview

  • Different ETL Products. Why Informatica?

  • Informatica Architecture

  • Components of Informatica tools (Server & Client)


Informatica Power Center 10.X:


 


PowerCenter Architecture and Components:



  • Introduction to Informatica PowerCenter

  • Overview on Informatica PowerCenter Architecture and Services

  • Extract, Transformation and Loading Process (ETL Process)

  • PowerCenter Tools explanation:


Server Tool - Administration Console


Client Tools - Repository Manager, Designer, Workflow Manager & Workflow Monitor



  • Overview on Informatica Admin Console, Creating Roles, Groups and Users and their permissions

  • Repository Security, Privileges, Folder Creation (Shared and Non-Shared) and Folder Permissions

  • OBDC creation and Usage

  • Transformation & Re-Usable transformation explanation, Mapplet, Mapping (Dynamic Mapping)

  • Lookup & Cache types and their usage

  • Mapping variable, Mapping parameter and Workflow variables

  • Web Service Sources and Targets Overview

  • Debugger and Performance tuning

  • Import and Export of Informatica object

  • Working with Deployment Group

  • Reusable/Dynamic mapping, session, worklet and workflow and their usage

  • Unix Basic command and advantages with Informatica.

  • Practical classes on Unix Environment

  • Practical on Real-time Scenarios

  • Overview on Version Control concept

  • Overview and discussion on real time unix script and making advantages with Informatica PowerCenter.


PowerCenter Developer Topics:


 


PowerCenter Designer:


 


Source Analyzer:



  • Source Object Definitions

  • Source Types

  • Source Properties

  • Create & Import source (Oracle, CSV and Flat Files – Fixed Width/Delimited)

  • Web service source definition


 


Target Designer:



  • Target Object Definitions

  • Target Types

  • Target Properties

  • Create & Import Source (Oracle, CSV and Flat Files – Fixed Width/Delimited)

  • Copying Source Object as Target Object

  • Add FileName Columns to Target Table (Dynamic Target Creation)

  • Web service target definition

  • Reverse engine (creating tables from target warehouse to database)


 


Transformation Concepts:



  • Transformations list and overview

  • Types of transformation and features (Active & Passive)

  • Difference between reusable and non-reusable transformation and usage

  • Difference between Transformation, Mapplets and Mappings

  • Source Qualifier Transformation and its usage/Advantage

  • Creating Mapipng, re-usable Transformation, mapplet, and mapping

  • Mapping Validation and Mapping Debugger

  • Mapplets usage and features

  • Lookup Caches and types

  • SQL Transformation (Static & Dynamic)

  • Data Flow rules and target load order

  • Web service Source & Target and its usage

  • Pre-SQL and Post-SQL and their usable


List of Transformations:


 

Date and Time

Not decided yet.

About the Trainer

K Gowtham picture

Avg Rating

0 Reviews

0 Students

3 Courses

K Gowtham

B.Sc Computer Science

I am working as Solution/Technical Architect and having 14 years of experience in development and migration project using Informatica tools. I have real time experience in Informatica tools like Informatica PowerCenter, Informatica Data Quality & Analyst, Informatica B2B DT, Informatica B2B DX, Informatica MDM, Informatica Mapping Analyst, Informatica Mapping Visio.
I have started teaching from last 8 years on Informatica and its tools. I have giving training around 250+ students online, offline, corporate training and freelance interviewer for MNC's. I have real time experience in Informatica related software's installation and configuration of services like Domain, PowerCenter Repository Service, Integration Service, Model Repository Service, Data Integration Service, Context Management Service (CMS), Analyst Service, Metadata Manager Service on both window and Unix platform.
All my training will be theoretically cum practical (50-50), this courses includes Datawarehousing concepts and ETL concepts.

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 PowerCenter With Administrator

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 Kamle

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