This training course lets learners grasp advanced skills like Informatica Installation, Configuration and Administration using PowerCenter 9.X. You will be able to test and monitor critical data processing using automated, scalable and auditable approach. Get trained in Workflow Informatica, Repository Management and other processes.
You don’t need any specific skills to learn Informatica. Basic knowledge of SQL can be helpful.
Topics: Introduction to data warehousing, what is ETL, and overview of data cleansing, data scrubbing, data aggregation, learn what is Informatica PowerCenter ETL.
Topics: Overview of Informatica configuration, Integration Services, Installation of Informatica, operational administration activities.
Topics: Learn what is active and passive transformation and the differences between the two.
Topics: Learning about expression transformation, connected passive transformation to calculate value on a single row.
Topics: The different types of transformations like Sorter, Sequence Generator and Filter, the characteristics of each and where they are used.
Topics: Joiner transformation to bring data from heterogeneous data sources.
Topics: Understanding the Ranking and Union transformation, the characteristics and deployment.
Topics: Learn about the rank and dense rank functions and the syntax for them.
Topics: Understanding how router transformation works and its key features.
Topics: Lookup transformation Overview and different types of lookup transformation:Connected, unconnected, Dynamic and Static
Topics: What is SCD?,processing in xml, learn how to handle flat file, list and define various transformations, implementing ‘for loop’ in power center, concepts of pushdown optimization and partitioning, what is constraint based loading?, what is incremental aggregation?
Topics: Different types of designer: Mapplet, Worklet, target load plan, loading to multiple targets, linking property
Topics: Objectives of performance tuning, defining performance tuning, learning the sequence for tuning
Topics: Managing repository, repository manager – client tool, functionalities of previous versions, important tasks in repository manager
Topics: Understanding and adopting best practices for managing repository.
Topics: Common tasks in workflow manager, creating dependencies, scope of workflow monitor, define variable and parameter in Informatica.
Topics: parameter files and their scope, parameter of mapping, worklet and session parameter, workflow and service variable, basic development errors
Topics: session and workflow log, using debuggers, error handling framework in informatica, failover and high availability
Topics: configurations and mechanisms in recovery, checking health of powercenter environment
Topics: infacmd, pmrep, infasetup, processing of flat file
Topics: Fixed length and delimited, expression transformations- sequence numbers, dynamic targeting using transaction control.
Topics: Dynamic target with use of transaction control, indirect loading.
Topics: Importance of Java transformations to extend Power Center capabilities, transforming data, active and passive mode.
Topics: Understanding unconnected stored procedure in Informatica, the different scenarios of unconnected stored procedure usage.
Topics: Use of SQL transformation (active and passive)
Topics: Understanding Incremental Loading and aggregation and comparison between them .
Topics: Working with database constraints using PowerCenter, understanding constraint based loading and target load order.
Topics: The various types of XML transformation in Informatica, configuring a lookup as active.
Topics: Push down optimization for load-balancing on the server for better performance, the various types of partitioning for optimizing performance.
Topics: Understanding session cache, importance of cache creation with, implementing session cache, calculating cache requirement
Data– Working with Admin Console
Topics– This is project that will help you understand the Informatica admin console. You will work on a real world scenario of creating and managing roles and responsibilities for various users and designing the various sessions and workflow in the Informatica ETL environment. This project also includes assigning users to groups, creating a collaborative environment, lock handling on repository objects of Informatica in order to develop a complete mastery of working with the Informatica tool.
In Intellipaat self-paced training program you will receive recorded sessions, course material, Quiz, related software’s and assignments.The courses are designed such that you will get real world exposure and focused on clearing relevant certification exam. After completion of training you can take quiz which enable you to check your knowledge and enables you to clear relevant certification at higher marks/grade also you will be able to work on the technology independently.
In Self-paced courses trainer is not available whereas in Online training trainer will be available for answering queries at the same time. In self-paced course we provide email support for doubt clearance or any query related to training also if you face some unexpected challenges we will arrange live class with trainer.
All Courses are highly interactive to provide good exposure. You can learn at your own place and at your leisure time. Prices of self-paced is training is 75% cheaper than online training. You will have lifetime access hence you can refer it anytime during your project work or job.
Yes, at the top of the page of course details you can see sample videos.
As soon as you enroll to the course, your LMS (The Learning Management System) Access will be Functional. You will immediately get access to our course content in the form of a complete set of previous class recordings, PPTs, PDFs, assignments and access to our 24×7 support team. You can start learning right away.
24/7 access to video tutorials and Email Support along with online interactive session support with trainer for issue resolving.
Yes, You can pay difference amount between Online training and Self-paced course and you can be enrolled in next online training batch.
Yes, we will provide you the links of the software to download which are open source and for proprietary tools we will provide you trail version if available.
Please send an email . You can also chat with us to get an instant solution.
Intellipaat verified certificates will be awarded based on successful completion of course projects. There are set of quizzes after each couse module that you need to go through . After successful submission, official Intellipaat verified certificate will be given to you.
Towards the end of the Course, you will have to work on a Training project. This will help you understand how the different components of course are related to each other.
Classes are conducted via LIVE Video Streaming, where you get a chance to meet the instructor by speaking, chatting and sharing your screen. You will always have the access to videos and PPT. This would give you a clear insight about how the classes are conducted, quality of instructors and the level of Interaction in the Class.
Yes, We do keep launching multiple offers, please see offer page.
We will help you with the issue and doubts regarding the course. You can attempt the quiz again.
This training course is designed for clearing the following Exams.
The entire training course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in the top MNCs.
As part of this training you will be working on real time projects and assignments that have immense implications in the real world industry scenario thus helping you fast track your career effortlessly.
At the end of this training program there will be a quiz that perfectly reflects the type of questions asked in the certification exams and helps you score better marks in certification exam.
Intellipaat Course Completion Certificate will be awarded on the completion of Project work (on expert review) and upon scoring of at least 60% marks in the quiz. Intellipaat certification is well recognized in top 80+ MNCs like Ericsson, Cisco, Cognizant, Sony, Mu Sigma, Saint-Gobain, Standard Chartered, TCS, Genpact, Hexaware, etc.
We provide 24X7 support by email for issues or doubts clearance for Self-paced training.
In online Instructor led training, trainer will be available to help you out with your queries regarding the course. If required, the support team can also provide you live support by accessing your machine remotely. This ensures that all your doubts and problems faced during labs and project work are clarified round the clock.
This course is designed for clearing “Informatica Professional Certification Exam” conducted by Informatica. At the end of the course there will be a quiz and project assignments once you complete them you will be awarded with Intellipaat Course Completion certificate.
"PMI®", "PMP®" and "PMI-ACP®" are registered marks of the Project Management Institute, Inc.
The Open Group®, TOGAF® are trademarks of The Open Group.
The Swirl logoTM is a trade mark of AXELOS Limited.
ITIL® is a registered trade mark of AXELOS Limited.
PRINCE2® is a Registered Trade Mark of AXELOS Limited.
Certified ScrumMaster® (CSM) and Certified Scrum Trainer® (CST) are registered trademarks of SCRUM ALLIANCE®
Professional Scrum Master is a registered trademark of Scrum.org