Informatica training is an industry-designed course for mastering the Informatica tool for ETL. You will learn how to configure, install and administer the PowerCenter. As part of the training, you will also do testing and monitoring of data processing using automated, scalable and auditable approach. You will get trained in Workflow Informatica, data warehousing, Repository Management and other processes.
What is data warehousing, understanding the extract, transform and load processes, what is data aggregation, data scrubbing and data cleansing and the importance of Informatica PowerCenter ETL
Configuring the Informatica tool and how to install the Informatica operational administration activities and integration services
Understanding the difference between active and passive transformations and the highlights of each transformation
Learning about expression transformation and connected passive transformation to calculate value on a single row
Different types of transformations like sorter, sequence generator and filter, the characteristics of each and where they are used
Working with joiner transformation to bring data from heterogeneous data sources
Understanding the ranking and union transformation, the characteristics and deployment
Learn the rank and dense rank functions and the syntax for them
Understanding how router transformation works and its key features
Lookup transformation overview and different types of lookup transformations: connected, unconnected, dynamic and static
What is SCD, processing in xml, learn how to handle a flat file, list and define various transformations, implement ‘for loop’ in PowerCenter, the concepts of pushdown optimization and partitioning, what is constraint-based loading and what is incremental aggregation
Different types of designers: Mapplet and Worklet, target load plan, loading to multiple targets and linking property
Objectives of performance tuning, defining performance tuning and learning the sequence for tuning
Managing repository, Repository Manager: the client tool, functionalities of previous versions and important tasks in Repository Manager
Understanding and adopting best practices for managing repository
Common tasks in workflow manager, creating dependencies and the scope of workflow monitor
Define the variable and parameter in Informatica, parameter files and their scope, the parameter of mapping, worklet and session parameters, workflow and service variables and basic development errors
Session and workflow log, using debuggers, error-handling framework in Informatica and failover and high availability in Informatica
Configurations and mechanisms in recovery and checking health of PowerCenter environment
Using commands: infacmd, pmrep and infasetup and processing of a flat file
Fixed length and delimited, expression transformations: sequence numbers and dynamic targeting using transaction control
Dynamic target with the use of transaction control and indirect loading
Importance of Java transformations to extend PowerCenter capabilities, transforming data and active and passive mode
Understanding the unconnected stored procedure in Informatica and different scenarios of unconnected stored procedure usage
Using SQL transformation (active and passive)
Understanding incremental loading and aggregation and comparison between them
Working with database constraints using PowerCenter and understanding constraint-based loading and target load order
Various types of XML transformation in Informatica and configuring a lookup as active
Understanding what data profiling in Informatica is, its significance in validating content and ensuring quality and structure of data as per business requirements
Understanding workflow as a group of instructions/commands for integration services and learning how to create and delete workflow in Informatica
Understanding the database connection, creating a new database connection in Informatica and understanding various steps involved
Working with relational database tables in Informatica, mapping for loading data from flat files to relational database files
Understanding how to deploy PowerCenter for seamless LinkedIn connectivity with Informatica PowerCenter
Connecting Informatica PowerCenter with various data sources like social media channels such as Facebook, Twitter, etc.
Pushdown optimization for load-balancing on the server for better performance and various types of partitioning for optimizing performance
Understanding session cache, the importance of cache creation, implementing session cache and calculating cache requirement
Course Rating
Bhava Bhardwaj-
-
-
-
-
- (5.0)
March 14, 2021Perfect Course
One of the best course I have ever come across. Very informative lecture. Presentation was great and very understandable. It is comprehensive that expose learner to core concepts.
Ananya Oberoi-
-
-
-
-
- (5.0)
March 04, 2021Good Course
Very good experience of listening, good knowledge and explanation. Topics are explained in simple terms making the subject more interesting. Was a good straight forward course.
Varun Rexwal-
-
-
-
-
- (5.0)
February 28, 2021Excellent Content
The course is overall very good. I really enjoyed the way you explained the concepts and it's very easy for me to understand the concepts. Thank you so much!!
Prabhdeep Singh-
-
-
-
-
- (5.0)
February 25, 2021Amazing Tutorials
Explanation of the concepts is good, but who is not from this world need a explanation which is easier to understand. Good Contents for the fundamental cover, and motivating one as well.
Rahul Madhok-
-
-
-
-
- (5.0)
February 16, 2021Best Course
Yes it's a very good match for me ..I learnt the relevant skills very well and hope to get more courses like this is the future. thank you ! SparkAcademy and the trainer for providing the students such a great information respective to their future.
Nancy Singhal-
-
-
-
-
- (5.0)
February 02, 2021Great Course
Explanations are very useful and are in simple language. Good content and material is provided in he course. overall a satisfactory experience achieved. Superb & simple, the presenter is also very easy to understand.
Karthik Dahiya-
-
-
-
-
- (5.0)
January 27, 2021Excellent tutorials
The course is pretty good and the homework material. This Course is a great match. Great content and even better delivery.
Pulkit Lunawat-
-
-
-
-
- (5.0)
January 15, 2021Perfect Course
I found this course excellent as a first step into understanding Informatica ETL. Very clear professional training package.
Prem Singhal-
-
-
-
-
- (5.0)
January 11, 2021Informative Course
Everything looks good. he started from a good point and challenged our minds. his accent also is good. SparkAcademy provides such amazing tutorials!!
Adiba Naz-
-
-
-
-
- (5.0)
January 07, 2021Good Course
This course is like an adventure in the Informatica ETL world, the instructor is confident about his knowledge and he also gives tips and tricks all the time to get in it.