Informatica
The course teaches the fundamental and advanced concepts of Informatica PowerCenter v9.x
- 4.7
- 105 Google reviews
Class Availability Weekdays & Weekends | Course Duration 40-45 Hours | Training Methodology 25% Theory & 75% Practical |
Class Availability
Weekdays & Weekends
Course Duration
40-45 Hours
Training Methodology
25% Theory & 75% Practical
4970
Profesionals Trained
350
Workshops Every Month
50
Countries And Counting
100
Corporate Served Successfully
Informatica PowerCenter v9.x (ETL)
The course teaches the fundamental and advanced concepts of Informatica PowerCenter v9.x, through online training including numerous hands-on lab exercises and real time scenarios. Students will gain a clear understanding of the product and acquire the solid foundation needed to make them efficient PowerCenter developers. Other top quality courses offered by IQ Stream Technologies Bangalore are Spring Java, Oracle Weblogic, JavaScript, IBM Datastage etc.
Objectives
- Understanding the concepts of Data Warehousing
- Ability to design and develop complex mappings
- Configuring Workflows as in real time environment
- Troubleshooting errors/failures
- Gain hands-on experience with multiple exercises and various real time scenarios and a Demo Project
- Build confidence to excel your career as an efficient Informatica Developer/Consultant
J2EE Syllabus
Advance JDBC Programming
- Overview of Database Driver Architecture
- Introduction to JDBC Standard Extension API (javax.sql)
- Connection Pooling
- JDBC Programming with ORACLE, MYSQL, etc.
- Batch Processing
- Working with Multiple Databases
Module #1 (Overview of Data Warehousing)
- Introduction to Data warehouse (What/Why/How)
- Star schema/Snowflake schema/Galaxy schema
- Dimensions/Facts tables.
- Slowly Changing Dimensions and its types.
Module #2 (Basic ETL)
- Introduction to Informatica PowerCenter
- (E)xtraction, (T)ransformation and (L)oading Process
- PowerCenter Tools (Repository Manager, Designer, Workflow Manager, Workflow Monitor)
- Source and Target Object Definitions
- Transformation Concepts (Types, Classifications, Basic uses)
- ODBC & Relational Connections
- Working with Flatfiles
- Working with XML Files
- Transformations:
- Filter
- Router
- Sequence Generator
- Rank
- Sorter
- Joiner
- Union
- Source Qualifier
- Expression
- Aggregator
- Lookup (Connected/Unconnected)
- Normalizer
- Stored Procedure (Connected/Unconnected)
- Update Strategy
- Transaction Control
- Java Transformation
- SQL Transformation (Query/Script)
- XML Parser
- XML Generator
Module#3 (Advanced ETL)
- Different Load Types
- Slowly Changing Dimensions (Type – 1/2/3)
- Indirect Method for Loading
- Mapplets and Reusable Transformations
- Parameters and Variables (Mapping and Workflow)
- Different Types of Tasks:
- Session
- Command
- Assignment
- Control
- Timer
- Decision
- Event Wait
- Event Raise
- Working with Link
- Worklets
- Scheduler
- Parallel and Serial Batching.
- User Defined Functions
- Incremental Aggregation
- Constraint Based Loading
- Target Load Plan
- Performance Tuning
- Pushdown Optimization
- Wizards
- Partitioning
- Debugger
Akhilesh Kumar
-
- 4.7
Positive: Communication, Professionalism, Quality, Value
It’s been pleasure taking the course of OIC at IQ Stream.
OIC training was good. Trainer Mr Bhaskar explained the topic nicely. He also provided the activities which helped hands on practice.
OIC training was good. Trainer Mr Bhaskar explained the topic nicely. He also provided the activities which helped hands on practice.
Ila Rana
-
- 4.7
Positive: Communication, Professionalism, Quality, Value
It’s been pleasure taking the course of OIC at IQ Stream.
Great Institute… Sachin is an excellent trainer for Oracle HCM Fusion…. strongly recommend this institute for enhancing skills
Great Institute… Sachin is an excellent trainer for Oracle HCM Fusion…. strongly recommend this institute for enhancing skills
gow thu
-
- 4.7
Positive: Communication, Professionalism, Quality, Value
IQ Stream institute provides a very good technical class in practical way and they conduct soft skill classes as well. The soft skills classes helped me a lot to improve my communication and it’s very good for the people who wants to improve their communication.