Informatica
Informatica is a data integration tool and as such provides native functionality for the export transform and loading of data.Informatica is a widely used ETL tool for extracting the source data and loading it into the target after applying the required transformation.Informatica enables organizations to gain a competitive advantage in today’s global information economy by empowering companies with timely, relevant and trustworthy data for their top business imperatives.
Objectives:
- Describe the Informatica PowerCenter architecture
- Explain Data Integration concepts
- Explain different Transformations & their usage
- Monitoring the PowerCenter Environment
- Understand design principles and best practices
- Explain repository manager tool
INFORMATICA POWERCENTER 9.1
DATAWARE HOUSING FUNDAMENTALS
DATAWARE HOUSING FUNDAMENTALS
- 1. What is Database?
- 2. What is Data Warehousing?
- 3. Difference between OLTP Database and DWH.
- 4. ETL FUNDAMENTALS.
- i) Data Extraction
- ii) Data Transformation
- iii) Data Loading
- 5. What is ETL Client?
- 6. DataMart and Types of Data Marts.
- 7. DataWareHouse-Database Design.
- i) Star Schema.
- ii) Snow Flake Schema.
- iii) Galaxy Schema.
- 8. OLAP and Types of OLAPs
- 9. DataWareHouse Architecture.
INFORMATICA POWERCENTER 9.1
-
1. Power Center Components.
- Power Center Clients
- Power Center Repository.
- Power Center Domain
- Integration service
- Repository Service
- Administration Console
-
2. Difference between Informatica 8.X and 9.X
3. Power Center Architecture
4. Integration Service Architecture
TRANSFORMATIONS
-
a). ACTIVE TRANSFORMATIONS.
- Filter Transformation
- Router Transformation
- Aggregator Transformation
- Joiner Transformation
- Union Transformation
- Sorter Transformation
- Rank Transformation
- Transaction Control Transformation
- Update Strategy Transformation
- Normalizer Transformation
- Source Qualifier Transformation
- SQL Transformation.
-
b). PASSIVE TRANSFORMATION
- EXPRESSION TRANSFORMATION
- SEQUENCE GENERATOR TRANSFORMATION
- STORED PROCEDURE TRANSFORMATION
- LOOKUP TRANSFORMATION (Upgradations in 9.X)
- XML SOURCE Qualifier Transformation.
c). CONNECTED AND UNCONNECTED TRANSFORMATIONS.
d). FLAT FILES AND ITS TYPES.
POWER CENTER ADVANCED
- 1). Unconnected lookup Transformation
- 2). Unconnected Stored Procedure to Create and Drop Index
- 3). Mapplet And Types Of Mapplets
- 4). Defining Reusable Transformations.
- 5). User Defined Functions.
- 6). Tasks And Types Of Tasks.
- 7). Worklet and Types Of Worklets.
- 8). Scheduling Work flow
- 9). Constraint Based Laod Ordering.
- 10). Target Load Plan
- 11). Types Of Batch Processing
- 12). Link conditions
- 13). Mapping Parameters
- 14). Mapping Variables
- 15). Defining Session Parameters
- 17). Session Recovery
- 18). Difference Between Normal and Bulk Loading.
- 19). Push Down Optimization.
- 20). PMCMD Utility
- 21). PMREP Utility
- 22). Incremental Aggregation
- 23). TYPES of LookUp Caches.
- Static LookUp Cache
- Dynamic LookUp Cache
- Persistence lookUp Cache
- Shared LookUp Cache
- 24). Sorter and Rank Cache.
- 25). ETL UNIT Testing (8 test Cases)
- 26). ETL PERFORMANCE TESTING (3 test cases)
- 27). ETL Performance
- Optimization techniques
- 28). Task Implementations.
- Session
- Command
- Timer
- Event Wait
- Event Raise
- Decision
- Assignment
- Control
- Worklet
Our distinct services include :
- Material and Documents: We provide real time working documents and materials to our students.
- Free System Access : We have the latest and most up to date platforms deployed on high-end servers that are available remotely and in-class on a 24/7 basis.
- Interview Preparation: We will prepare you for interviews in your specialized area by providing some real time interview questions. We also conduct mock interviews and assist you in preparing a professional resume.
- Placement Assistance: Our placement service division provides job placement support by submitting your resumes to prospective clients and emails you any new job opportunities in the market. However, we do not provide false guarantees on securing any jobs for you. We have a history of several ex-students who have secured excellent jobs based on our WORLD class training approach, implementation of case study projects and post training support.
- Initial Job Stabilization Support: We support our students to get stabilized in their job in the first TWO months. If our students come across any issues, we are there to help them. Students can send an email to us with their issues, our experts will reply back with possible solutions within 24 hours.
- Free Class Room sessions recording: In addition to the e-class training, we will give you authorization to record all of your e-class room training sessions, so that you can go back and review.
Other Courses related
Course registration
Instructor Led Hands-on eClassroom Training.
Key Points of Training Program :
Informatica Courses, Learn with Online Practice, in-class Seminars, Training and Certification from the list of world-class education trainers. Macropus provides Class Material, Tutorial Curriculum, Demo Videos, Sample Questions, Recommended Books, Tips and Tricks. Get lectures and practical lessons on development and programming to improve technical skills and Students will benefit with Job Placements, Visa.