Description
Informatica is one of the widely used ETL Tool for extracting the source data and loading it into the target after applying the required transformation. It provides a single enterprise data integration platform to help organization access, transform, and integrate data from a large variety of systems and deliver information to other transactional systems. Informatica is riding the wave of Data Integration currently in vogue to present its Certifications in Data Integration tools, with PowerCenter leading the pack. Special applications in ERP, manufacturing and HR alike have led to generation of data streams which need consolidation. This rising need in Data Integration and Data Warehousing is addressed by Informatica PowerCenter. PowerCenter offers continuous data processing with a zero-latency engine enabling business users to make timely decisions. It supports customer’s plans like data warehousing project, integrating or migrating applications, or evolving to a hybrid architecture and keeps their business agile.
Did you know?
1. Informatica has released Informatica cloud in 2016, to assist businesses in harnessing the exploding volume of data in their cloud applications and unifying data across traditional and hybrid data sources. Informatica cloud is mainly focused on delivering end-to-end cloud data integration and data management
2. Informatica being a 23-year-old company provides cloud based data management tools to their customers like General Electric GE and Amazon. It has a 22 percent share of the market for “integrated platform-as-a-service,” a cloud computing model that assists customers in developing applications and managing data over the internet
3. The key features of Informatica PowerCenter deals with partitioned data, caching techniques, parallel processing and quality bulk extraction or loading without any data loss. These key features has led Informatica PowerCentre as a market leader in data integration
4. Informatica follows mainstream marketing strategy where it leverages paperwork, press release, web forums and network community. This provides Informatica the leading edge in ETL space
Why learn and get Certified in Informatica PowerCenter (Developer)?
1. Based on 2015 market share revenue, gartner’s report announced Informatica as the #1 global Integration Platform as a Service (iPaaS) solution vendor for the 11th consecutive year. Its wide market share has raised ample of job opportunities for skilled professionals
2. In 2015, Informatica has generated over $1 billion in revenue. Now, it has plans to invest in startups, beef up its hiring capacity, and invest further in research and development to boost growth
3. It reports record of Quarterly Revenues of $303.7 Million and Annual Revenues of $1.05 Billion. Thus these revenue outcomes indicates the huge demand of Informatica Power Centre in the IT market
4. As per the latest job trends, the market of Informatica PowerCenter is highly profitable. It is an enduring technology and will be continuing progress with an exponential rate in the future as well
Course Objective
After the completion of this course, Trainee will:
1. Knowledge on Usage of PowerCenter 10 Designer to develop mappings that extract data from a source to a target, transforming it as per requirement
2. Ability to deploy PowerCenter transformations to format, cleanse, join, segregate and route data to appropriate targets
3. Potentiality to perform error handling or trapping by implementing PowerCenter mappings
4. Capability to develop and execute workflows which execute sessions paired with a mapping and to control data transformation processes by implementing PowerCenter, 10 workflow manager
5. Ability to plan and build basic mappings and workflows based on essential business needs
6. Complete knowledge on basic troubleshooting with help of PowerCenter debugger and logs
Informatica Supports the activity Process of the Business Integration Competency Center (ICC) and other integration experts by Serving as the foundation for data warehousing, data consolidation, migration, “single-view,” metadata management and synchronization. The Course we provide will give you Advance skills and Advance development knowledge to developers. In addition students shall be exposed to “Performance Oriented tuning techniques”, and some special features of the Tool.
Pre-requisites
1. Basic knowledge of PL/SQL and basic Unix development.
2. Students must be familiar with Concepts in Oracle database and its functionality.
3. Good knowledge of ETL, and Data Warehousing Concepts.
Who should attend this Training?
This comprehensive course is ideal and best suited for the following professionals, who are interested in mastering skills and upgrading their knowledge:
1. Individual Contributors in the field of Enterprise Business Intelligence
2. Analytics Professionals
3. DW/BI/ETL/ Professionals
4. Software Developers
5. Mainframe Architects and developers
Prepare for Certification
Informatica PowerCenter Role Based Training Program by US Global IT will prepare you for all the broad topics covered in the Informatica PowerCenter Developer Certification. US Global IT’s unique blended learning approach to its courses will give you an edge with a combination of online training augmented by market leading instructor-led training sessions for enhanced learning retention and query resolution.
How will I perform the practical sessions in Online training?
We use the Oracle version of Informatica. Students will have to register themselves on the Oracle Site (edelivery.oracle.com). Oracle provides the development license for all the Informatica PowerCenter Products. Software for training purpose will be made available to the candidates during the training.The detailed installation guides are provided in the LMS. In case you come across any doubt, the 24×7 support team will promptly assist you.
Informatica Power Center Course Syllabus
INTRODUCTION TO DATAWAREHOUSING
- Data Warehousing Concepts
- Dataware housing (what/Why/How)
- Data Modelling(Schemas, FACTS and DIMENSIONS)
- Slowly Changing Dimensions
- Metadata
PowerCenter Components and User Interface
- PowerCenter Architecture
- PowerCenter Client Tools
- Lab – Using the Designer and Workflow Manager
Introduction to Informatica Power Center Designer
- Source Analyzer
- Target Designer
- Mapping Designer
Informatica Power Center Workflow Designer
- Workflow Designer
- Task developer
- Work let Designer
Informatica Power Center Workflow Monitor
- Job status
- Job session logs
Loading Strategy
- Flat file to flat file load
- Flat file to database load
- Database to database load
- Database to flat file load
- Xml file to database load
- Xml file to flat file load
Different Transformations
- Source Qualifier
- Source Qualifier Join
- Source Qualifier Filter
- Expression
- Connected Stored Procedure
- Unconnected Stored Procedure
- Sequence Generator
- Aggregator
- Filter
- Lookup
- Joiner
- Router
- Rank
- Sorter
- Union Transformation
- Xml Source Qualifier
- Using Flat Files as Sources
- Using Flat Files as Source and Target
- Using XML Files as Source
- Reading Data From Multiple Data Bases
- Update Strategy
- Target Load Plan
Informatica Administration
- Installation of Informatica
- Installation of Oracle Database
- Installation of SQL Server
- Creation Repository
- Creation of Users
- Assigning Privileges to users
- Creation of Groups
- Adding the Repository to Informatica Repository Manager
- Creating Data source Connections
- Configuration of Sql server and Oracle Database with Informatica
- Scheduling the Workflow
Source Qualifier
- Source Qualifier Transformation
- Source Pipelines
- Source Qualifier Filter and Real time issues
- Source Qualifier SQL over query
Expression, Filter, File Lists and Workflow Scheduler
- Expression Editor
- Filter Transformation
- File Lists
- Workflow Scheduler
- Lab – Load the Customer Staging Table and Real time issues
Joins, Features and Techniques
- Joiner Transformation
- Shortcuts
- Lab – Features and Techniques I and Real time issues
Lookups and Reusable Transformations
- Lookup Transformation
- Reusable Transformations
- Lab A – Load Employee Staging Table
- Lab B – Load Date Staging Table and Real time issues
Debugger
- Debugging Mappings
- Lab – Using the Debugger
Sequence Generator
- Sequence Generator Transformation
- Lab – Load Date Dimension Table and Real time issues
Router, update Strategy and Overrides
- Router Transformation
- Update Strategy Transformation
- Expression Def ault Values
- Source Qualifier Override
- Target Override Session Task Mapping Overrides
- Lab – Load Employee Dimension Table and Real time issues
Unconnected Lookup, Parameters and Variables
- Unconnected Lookup Transformation
- System Variables
- Mapping Parameters and Variables
- Lab – Load Sales Fact Table
Sorter, Aggregator and Self-Join
- Sorter Transformation
- Aggregator Transformation
- Active and Passive Transformations Data Concatenation Self -Join
- Lab – Reload the Employee Staging Table and Real time issues
SCD type1
SCD type2
SCD type3
Mapplets
- Mapplets
- Review and more Activities and Real time issues
Worklets and More Tasks
- Worklets
- linkTask
- Lab – Load Inventory Fact Tabl
Certification
Certification assistance provided with proper guidance and certification notes.