Home / Business Intelligence Courses / Infomatica
Informatica Training
Course covers Power Center Architecture, Power Center Designer, Power Center Workflow Manager, Power Center Workflow Monitor, Unix,and SQL with Detailed Meterials, Software Installation and Daily Class Videos. Real-Time Projects, Real-Time ETL Scenarios and FAQ’S for to crack the interview.
Classroom | Online | Fast Track | Self Paced
Course Highlights
Live Projects
Placement Assistance
Expert Trainers
Premium Training
Live Video Share
Real-Time
Case Studies
Frequently Asked Questions
What is Informatica and What are it's uses?
Informatica is a data integration tool based on ETL architecture developed by Informatica Corporation. It provides data integration software and services for various businesses, industries and government organizations including telecommunication, health care, financial and insurance services.
It has many data transformation, cleansing and scrubbing processes to make data suitable for decision making.
Is Informatica easy to learn?
It is easy to learn, graphical interface to perform ETL and ELT Operations.
Does Informatica have a market?
Yes, It is very strong, robust & dynamic with current IT strategies, processes & cutting edge technologies.
It is providing on-premises & cloud service. So, Existing customers and new customers intercept towards the strong ETL platform informatica.
What if I miss a training session?
No need to worry, daily videos are in the class room folder and materials in the materials folder. You can watch and practice and also reach out to the trainer for queries.
What type of study materials and videos we will get and how long they are available?
You will get all materials after a week of your joining which you can download and use. Daily live class recordings will be placed in a folder and you will have access for maximum 12 months. Lab practice documents and required Power BI credentials provided for practice till one year.
Quick Enquiry
Why Join Vinay Tech
Why Join Vinay Tech
In-Depth Curriculum
Our educational program aims to comprehensively cover all & important points & aspects of the subject
Course Specialized Trainers
Our Trainers are high experienced industry experts with their teaching methods designed for their particular course
10+ Years of Experience
We’ve come a long way teaching from hundreds to thousands, so we use our experience in guiding students in the right path
Students Favourite
Vinay Tech House is prefered by many students as their favourite, rating as the best in teaching
Curriculum
Informatica Training in Hyderabad / Informatica Online Training with Real-Time Projects
INFORMATICA Real Time Training Designed for Aspiring:
- INFORMATICA Developers
- IT data storage areas [File stream, Database]
- INFORMATICA Leads
- INFORMATICA Testers
- INFORMATICA Consultants
- INFORMATICA Designer / Architects
Data warehousing fundamentals
- Data definitions (Data, Information, BI, Mining, ODS, DSS, Analysis, OLTP, OLAP, OLCP)
- Dwh Characteristics, Principles
- Dwh approaches (Top down/Bottom up)
- Dwh Life Cycle steps
- Data Mart & Types
- Data Processing Types (OLAP)
- Granularity and various granularities
- Diff between OLTP and OLAP
Dimensional Modeling Fundamentals
- Dimension, Dimension Table & types
- Fact, Fact Table & measures types
- Fact less fact table
- Various schemas (Star, Snow Flake, Galaxy & Hybrid )
- Surrogate key and usages in real time
- Model, Business, Conceptual, Logical, Physical Data Models
Informatica Powercenter Content, Data Warehouse, Data Model Fundamentals & Project Content
IT Data Fundamentals & INFORMATICA Existence
- Data, Data Availability in IT
- IT data storage areas
- Datawarehouse, BI definitions, and layers
- INFORMATICA existence in IT and Product services
- INFORMATICA Definition
- INFORMATICA Tools and Components
- INFORMATICA Opportunities
INFORMATICA and Competitiveness
- What are BI, OLAP, and OLTP? Importance in the current Enterprise?
- Competitive advantages
- INFORMATICA vs Other ETL TOOLS
- SQL History, SQL Extensions, and Need of SQL
- Hardware & Software requirements
- Installation Process [ Classroom & Online]
Data warehousing fundamentals
- Data definitions (Data, Information, BI, Mining, ODS, DSS, Analysis, OLTP, OLAP, and OLCP)
- Dwh Characteristics and Principles
- Dwh approaches (Top down/Bottom up)
- Dwh Life Cycle steps
- Data Mart & Types
- Data Processing Types (OLAP)
- Granularity and various granularities
- Diff between OLTP and OLAP
Dimensional Modeling Fundamentals
- Dimension, Dimension Table & types
- Fact, Fact Table & measures types
- Fact less fact table
- Various schemas (Star, Snow Flake, Galaxy & Hybrid )
- Surrogate key and usages in real time
- Model, Business, Conceptual, Logical, and Physical Data Models
Informatica Architecture, Concepts & Components
ETL Concepts
- What is ETL?
- Methods of Data Extraction
- Types of Transformations
- Types of Data Loading
Introduction to Informatica
- Informatica products stack
- Introduction to PowerCenter 9.X
- Key components in PowerCenter
- PowerCenter Architecture
- PowerCenter client tools
- Designer
- Repository Manager
- Workflow Manager
- Workflow Monitor
Introduction to PowerCenter Workflow Monitor
- Designer Concepts:
- What is mapping?
- Types of ports
- Mapping validation rules
- Steps in creating and executing a mapping
- Importing/Creating Source Definitions
- Importing/Creating Target Definitions
- Transformation and types of transformations
- Power Center Transformation Language
Designer Tools:
- Source Analyzer
- Target Designer
- Transformation Developer
- Mapplet Designer
- Mapping Designer
- Creating ODBC connections
Workflow Manager
- Workflow Manager tools::
- Task Developer
- Worklet Designer
- Workflow Designer
- Creating relational connections
PowerCenter Transformations
- Filter Transformation
- Router Transformation
- Expression Transformation
- Aggregator Transformation
- Rank Transformation
- Sorter Transformation
- Joiner Transformation
- Lookup Transformation
- Update Strategy Transformationv
- Union Transformation
- Union Transformation
- Source Qualifier Transformation
- Sequence Generator Transformation
- Transaction Control Transformation
- Normalizer Transformation
- Stored Procedure Transformation (Connected/Unconnected)
- SQL Transformation
- Java Transformation
- Working with Flat file sources and targets
- XML Files
- Session Partitioning
- Normal and Bulk Loading
- Push Down Optimization
- Dynamic file generation
- Scheduling workflows
- Performance tuning
- Object sharing
- Copy and Paste
- Shortcuts
- Import and Export objects
- PMCMD Utility
- PMREP Utility
Slowly Changing Dimensions:
- Implementation of Slowly Changing Dimensions
- Type -1
- Type -2
- Type -3
- Type -6
- Mapping Debugging
PowerCenter – Workflow Manager
- Implementation of Slowly Changing Dimensions
- What is workflow?
- Link conditions?
- Session configuration
- Creating Workflow
- Execution of workflow
- Monitoring result and trouble shooting
Advanced Concepts
- Mapplet and Types of Mapplets
- Reusable transformations
- User Defined Functions
- Mapping Parameters and Variables
- Difference between mapping variable and variable port
- Target load plan
- Constraint based loading
- Worklets and types of Worklets
- Scheduling Workflows
- Types of Batch Processing
- Link conditions
- Session Parameters
- Session Recovery
Real-Time Environment
- Agile Life Cycle Model [Scrum and Sprint process]
- Team Foundation Server, PVCS, and Sub version
- Developer, Support, and Admin responsibilities
Types of tasks
- Assignment
- Command
- Control
- Decision
- Event
- Ses
Projects for practice
- Banking Datawarehouse implementation [ICDW]
- Retail Warehouse Implemenation [MEDW]
- Telecommunications Data Warehouse and Analysis
ETL testing lifecycle
- Unit Testing
- System Testing
- UAT/Performance Testing
Projects Covered
Retail Datamart Preparation
Creating & Lodging Retail Datamart data by using Mappings
Case Study
Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut elit tellus, luctus nec ullamcorper mattis, pulvinar dapibus leo.
Interested in a Free demo? Want to learn more?
Get Certified by Vinaytech House
Vinay Tech’s course completion certificate will be provided upon the completion of the
course successfully. It increases the value of your resume and you can attain leading
job posts with the help of this certification in leading MNCs. The certificate can be printed out
like a hard copy or handed digitally.
Need help with Microsoft ETL Certification?
Our Student Say!
Our Learners Work At
