This course gives you practical, immediately useful skills on the Informatica family of enterprise data integration products. You will learn to power your organization's data engineering and analytics strategies by using Informatica to access and integrate data from any business system, in any format, and deliver that data throughout the enterprise.
On today's enterprise teams, understanding how to intelligently manage and leverage the vast amounts of data your organization uses in a way that provides holistic, strategic business value is a must. By the end of this class, you will understand how to use Informatica data integration products and how they enable a coherent strategy for managing, preparing and integrating data throughout the enterprise.
- Upcoming Dates and Locations
Guaranteed To Run
- Course Outline
Part 1: Introduction to Extract, Transform, Load (ETL)
- What does it mean?
- How do I identify my sources?
- Identify common issues
- Understand Master Data Management and quality control within the integration process
- Utilizing transform phase to address common problems
- What does it mean?
- How do I identify my targets?
Activity: Students will be presented with a business scenario and will need to identify the sources the data should be extracted from, what types of transformations might be useful to maintain data quality and finally where the data should move to post-transformation.
Part 2: Introduction to Informatica Product Suite
- Identify data integration requirements
- Informatica value proposition
- Why use Informatica?
- Data Integration Architecture
- Explore the Informatica architecture
- Informatica use cases
- Introducing the Informatica Data Integration Products
- Data Explorer
- Data Validation
- Metadata Manager
Activity: Students will be placed in groups and given a scenario and should create a use case diagram that identifies which tools should be utilized to solve data problems across the business process. They should be identifying the correct tool at the correct time in the process.
Part 3: Introduction to Informatica Developer
- Using the Informatica Analyst tool
- Creating project
- Profiling data
- Create rules in profiles
- Score Data
- Manage Data quality issues
- Creating reference tables from profile results
Activity: Students will create a new project that will be used to profile a sample data set provided for this activity. They will experiment with profile rules, data scoring, and reference table management.
Part 4: Introduction to PowerCenter
- Building mappings to extract data from sources
- Building sources with PowerCenter
- Exploring the Source Analyzer
- Creating target definitions
- Automatic target creation
- Definition importing
Activity: In this activity students will use the source analyzer to build sources from the sample data provided. They will also develop targets for the purpose of migrating the data from its source to a staging table.
Part 5: Introduction to data transformations
- Implementing transformations
- Transformation types
- Transformation views
- Expression driven transformations
- Variable ports
- Data types
Part 6: Working with advanced transformations
- Explore the mappings designer
- Advanced topics
- Filter transformations
- Aggregator transformations
- Joiner transformations
- Sorter transformations
- Lookup transformations
Activity: Instructor-led demo of PowerCenter Project Management
Activity: Students will take the result of the activity at the end of day 1 and turn it into a model within PowerCenter. Students will recreate the conceptual model that encompasses all the departments. This will reinforce the ideas of entities and relationships and get students thinking about the complexity of relating data across departments.
Part 7: Introduction to the Metadata Manager
- Defining metadata models
- Metadata defined
- Types of Metadata
- Metadata management overview
- Metadata management lifecycle
- Metadata Manager
- Key features
- Data lineage
- Impact analysis
- Business Glossary
- Loading and linking external metadata
- Building custom metadata models
- Loading business glossaries
- Linking glossary terms with technical metadata objects
- Browse and search the metadata catalog
- Interacting with lineage diagrams
Activity: In this activity students will have the opportunity to work with the Metadata Manager. Special emphasis will be placed on the data lineage and impact analysis components.
Part 8: Introduction to PowerExchange
- Using the PowerExchange Navigator
- Introduction to data maps
- PowerExchange/PowerCenter integration
Activity: In this activity, the students will work with PowerExchange data maps and experiment with the integration between PowerExchange and PowerCenter
Part 9: Course Conclusion
- Recapping what you’ve learned in class
- Specific questions and student use cases
- What will you do back at work?
- Q & A and class closing
- Who should attend
This course is designed for anyone in the enterprise utilizing a data component or integrating a data service into their job role or project, and who wish to use Informatica as their tool for doing so. The workshop is invaluable for:
- Data engineering and DBA professionals
- ETL Developers
- Developers integrating data services for applications
- Analytics and reporting professionals
- Business intelligence professionals
- Data modelers & analysts
- Data warehousing & data mart staff
- Cross-functional teams integrating data
This course is designed for organizations who have an Informatica license and can provide the necessary tool environment for the hands-on lab portions of the class. We cannot provide a simulated Informatica environment.