This course will help you to c master advanced concepts like installation & configuration, Informatica Architecture, advance Informatica transformations, performance tuning, data migration, Power center ETL tool, data integration and data warehousing concepts.
Mainframe and database Professionals
ETL & SQL Developers
Data Warehousing and Cleansing Concepts
Informatica Installation and Configuration
Working with active and passive transformation
Working with expression transformation
Working with Sorter, Sequence Generator, Filter transformation
Working with Joiner Transformation
Working with Ranking and Union Transformation
Syntax for Rank and Dense Rank
Source Qualifier Transformation and Mappings
Slowly Changing Dimension in Informatica
Mapplet and loading to multiple designer
Performance Tuning in Informatica
Best Practices in Informatica
Parameters & Variables
Error handling and recovery in Informatica
High Availability & Failover in Informatica
Working with different utilities in Informatica
Flatfile processing (advance transformations)
Working with Java transformations
Unconnected Stored Procedure usage
Advance Concepts in SCD
Incremental Data Loading and Aggregation
Constraint based loading
XML Transformation and active look up
Profiling in PowerCenter
Workflow Creation and Deletion
Relational Database Tables
Connection with Sources
Push down optimization & Partitioning
FACTS ABOUT THE COURSE
Informatica architecture and PowerCenter
Informatica installation and configuration
Informatica workflow monitoring and managing
Jobs and Tasks handled by power centers
workflow variables and session parameters
Informatica Admin Console
performance tuning of Informatica
Managing Informatica Repository
ETL functionalities and scenarios
Informatica SQL and XML transformation
In the ETL segment, Informatica is the market leader with the wide variety of data sets, varying standards and multiple applications and systems which is rapidly being adopted by organizations across the world where there is a huge job opportunity for professionals with the right skills.
What are the various modes of training that SAN IT offers?
If you have any queries we provide email support and solution to queries. You can raise your queries even after completion of training to get support and assistance.
Do you provide placement assistance?
Yes, Blue Ocean does provide you with placement assistance and the process of preparing yourself for the interview and the job.
What kind of projects will I be working on?
We provide real-world projects wherein you can apply your knowledge and skills that you acquired through our training. Making you perfectly industry-ready.
Can I still learn Android without a programming background?
We provide add-on courses in java so that you can start learning programming skills which will help you in understanding Hadoop technology better and faster.
Subscribe to our newsletter to receive news, cool free stuff updates and new released products (no spam!)
About our Company
SAN IT Solutions is one of the leading organizations in India, engaging in the field of Training & Development, Staffing, and Consulting Program. It has earned a world-class learning culture in its relevant fields. We are run by a dedicated professional team with an aim of providing world−class education for the growth of youths all over India.