Informatica Training Course Syllabus in Chennai
Informatica syllabus covered by MNC Expert is completely in real time and industry based syllabus which are used in real time.
100% Real Time Informatica Course Content Designed by MNC Expert who is Certified in Informatica.
Data Warehouse Concepts:
Introduction to Data warehouse
What is Data warehouse and why we need Data warehouse
OLTP vsData warehouse
Dimensional modelling
Star schema/Snowflake schema
Dimensions / Facts tables.
Slowly Changing Dimensions and its types.
Different types of Dimensions and Facts.
Data Mart vs. Data warehouse
DWH Approaches: Ralph Kimball's vs. Bill Inmon's
E T L Informatica PowerCenter 9.x:
Introduction to Informatica PowerCenter
Informatica Architecture
PowerCenter Components
Designer
Repository Manager
Workflow Manager
Workflow Monitor
Informatica Concepts and Overview
Source Qualifier
Target Analyzer
Transformations
Mappings
Mapplets
Sessions
Tasks
Sources
Working with relational Sources
Working with Flat Files
Targets
Working with relational Sources
Working with Flat Files
Transformations
Source qualifier transformation
Joiner Transformation
Filter Transformation
Lookup Transformation
Aggregator Transformation
Expression Transformation
Normalizer Transformation
Rank Transformation
Router Transformation
Union Transformation
Sequence Generator Transformation
Stored Procedure Transformation
Sorter Transformation
Update Strategy Transformation
Reusable mapplets and transformations
Mapping Variables & Parameters
Workflow Manger-Workflows & Sessions
Scheduling
Unit Testing
Interview Questions
Informatica Server and Client installation
Oracle Server installation
Case study and real time scenarios
Administrator Module
Understanding Domains
Nodes
Application Services
Using Administration Console
Managing the Domain
Managing Alerts
Managing Folders
Managing Permissions
Managing Application Services
Managing the Nodes
Managing Users and Groups
Managing Privileges and Roles
Domain Privileges
Repository Services Privileges
Reporting Service Privileges
Managing Roles - Assigning Privileges and Roles to Users and Groups
Creating and Configuring the Repository Services
Managing the Repository
Creating and Configuring Integration Services
Enabling and Disabling the Integration Services
Running in Normal and Safe Mode
Configuring the Integration Services Processes
Integration Services Architecture
Creating the Reporting Services
Managing the Reporting Services
Configuring the Reporting Services
Managing License
Advanced Workflow Module
Understanding Pipeline Partitioning
Partitioning Attributes
Dynamic Partitioning
Partitioning Rules
Configuring Partitioning
Partitioning Points
Adding and Deleting Partitioning points
Partitioning Relational Sources
Partitioning File Targets
Partitioning transformations
Partitioning Types
Real Time Processing
Commit Points
Workflow Recovery
Stopping and Aborting
Error Handling
Stopping and Aborting Workflows
Concurrent Workflows
Load Balancer
Workflow Variables
Predefined Workflow Variables
User- Defined Workflow Variables
Using Worklet Variables
Assigning Variable Values in a Worklet
Parameter and variables in Sessions
Working with Session Parameters
Assigning Parameter and Variables in a Session
Parameter File
Session Caches
Incremental Aggregation
Session Log Interface
Command Reference:
Using Command Line Programs
Infacmd
Infasetup
Pmcmd
pmrep
Designer Module
Using the Designer
Configuring Designer Options
Using Toolbars
Navigating the Workspace
Designer Tasks
Viewing Mapplet and Mapplet Reports
Working with Sources
Working with Relational Sources
Working with COBOL Sources
Working with Cobol Source Files
Working with Flat Files
Importing Flat Files
Editing Flat Files Definition
Formatting Flat Files Column
Working with Targets
Importing Target Definition
Creating Target Definition from Source Definition
Creating Target Definition from Transformations
Creating Target tables
Mappings
Working with Mappings
Connecting Mapping ObjeMNC
Linking Ports
Propagating Port Attributes
Working with Targets in a Mapping
Working with Relational Targets in a Mapping
Validating a Mapping
Using Workflow Generation Wizard Mapplets
Understanding Mapplets Input and Output
Using Mapplet Designer
Using Mapplets in Mapping
Mapping Parameters and Variables
Working with User-Defined Functions
Using the Debugger
Creating Breakpoints
Configuring the Debugger
Monitoring the Debugger
Evaluating Expression
Creating Cubes and Dimensions
Using Mapping Wizard
Naming Conventions
Performance Tuning Module
Performance Tuning Overview
Bottlenecks
Using Thread Statistics
Target Bottlenecks
Source Bottlenecks
Mapping Bottlenecks
Session Bottlenecks
System Bottlenecks
Optimizing the Targets
Optimizing the Source
Optimizing the Mapping
Optimizing the Transformations
Optimizing the Sessions
Optimizing thePowerCenter Components
Optimizing the System
Using Pipeline Partitions
Performance Counters
Repository Module
Understanding the Repository
Using Repository Manager
Folders
Managing Object Permissions
Working with Versioned Object
Exporting and Importing Object
Copying Object
Transformation Module
Working with Transformations
Configuring Transformations
Working with Ports
Working with Expressions
Reusable Transformations
Aggregator Transformation
Custom Transformation
Expression Transformation
External Transformation
Filter Transformation
Joiner Transformation
Java Transformation
Lookup Transformation
Lookup Caches
Normalizer Transformation
Rank Transformation
Router Transformation
Sequence Generator Transformation
Sorter Transformation
Source Qualifier Transformation
SQL Transformation
Stored Procedure Transformation
Transaction Control Transformation
Union Transformation
Update Strategy Transformation
Transformation Language Reference:
The Transformation Language
Constants
Operators
Variables
Dates
Functions
Creating Custom Function
Workflow Basics Module
Workflow Manager
Workflow Manager Options
Navigating the Workspace
Working with Repository ObjeMNC
Copying Repository ObjeMNC
Comparing Repository ObjeMNC
Workflow and Worklets
Creating a Workflow
Using Workflow Wizard
Assigning an Integration Service
Working with Worklets
Working with Links
Sessions
Creating a Session Task
Editing a Session
Pre- and Post- Session Commands
Session Configuration ObjeMNC
Tasks
Creating a Task
Configuring Tasks
Working with Command Task
Working with Decision Task
Working with Event Task
Working Timer Task
Working with Assignment Task
Sources
Configuring Sources in a Session
Working with Relational Sources
Working with Flat Sources
Targets
Configuring Targets in a Session
Working with Relational Targets
Working with File Targets
Reject Files
Validation
Validating Tasks
Validating Worklets
Validating Session
Validating Workflows
Scheduling and Running Workflows
Scheduling a Workflow
Manually Starting a Workflow
Sending Email
Working with Email Tasks
Working with Post-Session Email
Workflow Monitor
Using Workflow Monitor
Customizing Workflow Monitor Options
Working with Tasks and Workflows
Using Gantt Chart View and Task View
Workflow Monitor Details
Integration Services Properties
Workflow Run Properties
Worklet Run Properties
Session Task Run Properties
Performance Details
Session and Workflow Logs
Log Events
Log Events Window
Working with Log Files
Workflow Logs
Note: Lab sessions for all the points mentioned above will be taken.
DATAWAREHOUSING SYLLABUS
Evolution of Datawarehousing - History
The need of Datawarehousing
Why Datawarehousing
What is Datawarehousing - The Definition
Subject -Oriented
Integrated
Non - Volatile
Time Varying
Datawarehousing Architecture
Data Source Layer
Data Extraction Layer
Staging Layer
ETL Layer
Data Storage Layer
Data Logic Layer
Data Presentation Layer
Metadata Layer
System Operation Layer
Dimension table
Fact table
Additive FaMNC
Semi Additive FaMNC
Non - Additive Fact
Cumulative
SnapShot
Attribute
Hierarchy
Types of Schema
Star Schema
Snow Flake Schema
Fact Constellation Schema
Slow Changing Dimension
SCD1 - Advantages/ Disadvantages
SCD2 - Advantages/ Disadvantages
SCD3 - Advantages/ Disadvantages
OLAP and OLTP
Difference between OLAP and OLTP
Types Of OLAP
Multi-Dimentional (MOLAP)
Relational(ROLAP)
Hybrid(HOLAP)
Informatica Trainer profile at IICT, Chennai
Informatica Training in Chennai Benefits
Informatica training batch size in Chennai
Regular Batch ( Morning, Day time & Evening)
Weekend Training Batch( Saturday, Sunday & Holidays)
Fast Track Batch (4+ Hours daily)
Informatica training duration in Chennai
Regular Classes( Morning, Day time & Evening)
Weekend Training Classes( Saturday, Sunday & Holidays)
Fast Track Training Program( 5+ hours daily)
Informatica training Location in Chennai
Our Informatica Training center
Contact Us
No.14/22, Third Floor,
First Cross Street, Newcolony,
Chrompet, Chennai- 600 044.
Land Mark: Near Chrompet Railway Station and Bus Stop, Behind Sri Krishna Sweets.
Land Line: 044 - 4283 3515 / 90038 53466
No.14/22, Third Floor,
First Cross Street, Newcolony,
Chrompet, Chennai- 600 044.
Informatica training in Chennai Reviews
Informatica Training in Chennai
Reviewed bySaranya - Informatica Trained Student at IICT, Chennaion Hi this is Saranya - Informatica Trained Student at IICT, Chennai completed my informatica course to MNC Expert.He is excellent trainer for informatica.
Rating:
5/5 
Reviewed by
Saranya - Informatica Trained Student at IICT, Chennai
on
Hi this is Saranya - Informatica Trained Student at IICT, Chennai completed my informatica course to MNC Expert.He is excellent trainer for informatica.
Rating:
5/5
Informatica Training in Chennai
Reviewed byGeetha - Informatica Trained Student at IICT, Chennaion Hi this is geetha from namakal i got training from MNC Expert, he showed all the concepts in real time and practical manner.Excellent institute for Informatica training in chennai
Rating:
5/5
Reviewed by
Geetha - Informatica Trained Student at IICT, Chennai
on
Hi this is geetha from namakal i got training from MNC Expert, he showed all the concepts in real time and practical manner.Excellent institute for Informatica training in chennai
Rating:
5/5
Informatica Training in Chennai
Reviewed bySanthosh - Informatica Trained Student at IICT, Chennaion Hi this Santhosh - Informatica Trained Student at IICT, Chennai i have almost 5+ years of experience in oracle domain.I have undertaken Informatica Training in Chennai.My trainer was MNC Expert , he trained me in real time and practical training.Overall excellent for Informatica Training in Chennai.
Rating:
5/5
Reviewed by
Santhosh - Informatica Trained Student at IICT, Chennai
on
Hi this Santhosh - Informatica Trained Student at IICT, Chennai i have almost 5+ years of experience in oracle domain.I have undertaken Informatica Training in Chennai.My trainer was MNC Expert , he trained me in real time and practical training.Overall excellent for Informatica Training in Chennai.
Rating:
5/5
Informatica Training in Chennai
Reviewed bySaranya - Informatica Trained Student at IICT, Chennaion Complete Real time and best training in chennai for Informatica.The trainer is vast experienced and MNC Expert. I am thankful to Sathik sir and IICT simply great training center in chennai for Informatica.
Rating:
5/5
Reviewed by
Saranya - Informatica Trained Student at IICT, Chennai
on
Complete Real time and best training in chennai for Informatica.The trainer is vast experienced and MNC Expert. I am thankful to Sathik sir and IICT simply great training center in chennai for Informatica.
Rating:
5/5
Informatica Training in Chennai
Reviewed byMadhusudhan - Informatica Trained Student at IICT, Chennaion IICT is the best training institute in chennai for Informatica.IICT provides complete real time and practical training in Informatica in chennai.
Rating:
5/5
Reviewed by
Madhusudhan - Informatica Trained Student at IICT, Chennai
on
IICT is the best training institute in chennai for Informatica.IICT provides complete real time and practical training in Informatica in chennai.
Rating:
5/5
Wow!! i am very impressed with your lovely post.. I am so glad to left comment on this..This has been a so interesting read, would love to read more here
ReplyDeleteIOS Training in Chennai |
iOS Training Institutes in Chennai |
iOS Training
Pharmacy Management System helps the organisation to keep a track of all the information related to the pharmacies.
ReplyDeleteWeb Designing Course in chennai |
web designing training in chennai |
Web Development courses in Chennai