Informatica Course Syllabus

Introduction

If you are interested in learning Informatica, our Informatica course syllabus could help you gain the required skills, talents and knowledge. Our course content is designed for beginners as well as seasoned professionals who want to hone their skills and improve their expertise in the software industry. You might be a data engineer or data analyst or data scientist, our curriculum would help you gain the knowledge and skills you need to excel in the field of IT. Our instructor-led Informatica course in Chennai will help you learn core Informatica concepts through many different practical examples.

Informatica Course Syllabus

Introduction to Informatica

• Basic Definitions
• Informatica Products
• Informatica Architecture
• Tools and their roles
• Folders -sub Folders
• Power Center I Power Malt
• Introduction to designer

Informatica Designer -Introduction

• Designer interfaces
• Designer tools
• Defining Sources
• (i) Database as a source
• (ii) Rat Flies sources
• Defining Targets
• Importing from database
• Creating a new target
• Creating target database objects
• Mapping Introduction

Informatica Designer

• Source Qualifier
• Ports
• Mapping -Table to Table
• Mapping flat File to Table
• Connected/Unconnected Transformations
• Active and Passive Transformation
• Source Qualifier Transformation
• SQl Override-Source Qualifier Transformation

Mapping Source Qualifier as Filter

• Source qualifier to join Data
• Filter Transformation
• Expression Transformation
• Sequence Generator Transformation
• Rank Transformation
• Router Transformation
• Aggregator Transformation
• Joiner Transformation
• Stored procedure Transformation (Connected & Unconnected)
• Union Transformation
• XMl Transformation
• Mapping Wizards
• Implementing Type-I, Type-II, Type-III
• Mappings
• Workflow Introduction

Data Warehousing Concepts

• Data Warehouse
• Data Mart
• OLAP VS OLTP
• Data Warehouse Architecture (Basic)
• Data Warehouse Architecture (with a Staging Area)
• Dimensional Modeling
• Star Schema
• Snowflake Schema
• Dimension
• Fact
• Slowly Changing Dimension(Type 1,2 and3)
• Hierarchy
• Confirmed Dimension
• Fact less Fact Table.
• Summary / Aggregations table
• Change Data capture

 Sources

• Working with relational Sources
• Working with Flat Files

Targets

• Working with Relational Targets
• Working with Flat file Targets

Transformations

• Expression Transformation
• Lookup Transformation
• Sequence Generator Transformation
• Filter Transformation
• Joiner Transformation
• Sorter Transformation
• Procedural Transformation
• Router Transformation
• Aggregator Transformation
• Update Strategy Transformation
• Union Transformation
• Rank Transformation
• Transaction Control Transformation
• Normalizer Transformation
• Source Qualifier Transformation
• Stored Procedure Transformation
• XML Source Qualifier Transformation
• Debugging Mappings

Advanced Informatica concepts

• Unconnected lookup Transformation
• Unconnected Stored Procedure to Create and Drop Index
• Mapplet and Types of Mapplets
• Defining Reusable Transformations.
• User Defined Functions
• Tasks And Types of Tasks
• Worklet and Types of Worklets
• Scheduling Work flow
• Constraint Based Load Ordering
• Target Load Plan
• Types of Batch Processing
• Link conditions
• Mapping Parameters
• Mapping Variables
• Defining Session Parameters
• Session Recovery
• Difference Between Normal and Bulk Loading
• Push Down Optimization
• PMCMD Utility
• PMREP Utility
• Incremental Aggregation

ETL Testing

• UNIT Testing
• System Integration testing
• PERFORMANCE TESTING
• ETL Performance Optimization techniques

Conclusion

Our Informatica course syllabus is expertly designed to provide students with comprehensive knowledge of Informatica. Our course content covers Informatica designer, Informatica architecture, Informatica workflow manager and advanced features of Informatica. Our Informatica training in Chennai will come with many real-time projects and would make you ready for the professional Informatica certification. We provide top-notch training that covers basic knowledge on core concepts with a hands-on approach. With the help of our course curriculum, you can easily scale up your skills and perform real-time projects with the finest practices.