Informatica Training
Magna Training offers the best Informatica training available on the planet. Period. Our Informatica training course is suitable for both freshers as well as experienced folks.
RegisterHere is a brief structure of the course.
Informatica contains a set of tools ( Informatica Power Center, Data Quality, Data Transformation and many more ) with its ETL (Extraction, Transformation & Load ) toolset being the most widely used in the industry.
Additional Freebies – Along with the training we provide the following additional services.
- One Month of Informatica support (After training, During the practice).
- Mock Interviews.
- Interview Tips.
- Resume Marketing
Intended Audience – Informatica is intended for any of the following audience.
- Experienced Business Users who have been working extensively in Data Warehousing.
- Less than 1 yr of experience in Informatica or other DWH tools and wish to further renew his/her skills.
- Fresh Graduates
Table of Contents
Data Warehousing Basics
(Week 1 )
- What is Data Warehousing
- Why Use a Data Warehouse ?
- Available Tools in the Market
- Key Terms
- Architectural Concepts
- Primary Components
- What is ETL ?
- Data Cleansing
- Data Merging
- Data Aggregation
- Data Scrubbing
Data Warehousing Concepts
( Week 2 )
- Historic Data
- Current Data & Historical
- Complete History
- Limited/Unlimited Number of Histories
- Load Types
- First Time Load ( Initial Extraction )
- Delta Load
- Full Load
- Incremental Loads
- Schema Types
- Star Schema
- Snowflake Schema
- Integrated Star Schema
- Advantages of Each Schema
- Dimensional Modeling Techniques
- Conceptual Modeling
- Logical Modeling
- Physical Modeling
- Named Input
- Formatted Input
Data Warehousing Concepts .. Continued
( Week 3 )
- Data marts
- Concept
- Dependent vs Independent Data Mart
- Enterprise Warehouse Schema
- Implementation Methodology
- Kimball Methodology
- Inmon Methodology
- Facts
- Additive Facts
- Semi Additive Facts
- Non Additive Facts
- Measures
- HPQs
- Dimension Table Types
- Slowly changing Dimensions
- Type 1/2/3 Dimensions
- Zunc Dimensions
- Confirmed Dimensions
- Need of Time Dimension Comparison
Data Warehousing Concepts.. Continued
(Week 4 )
- Why is BI (Business Intelligence ) Required ?
- OLTP
- DSS
- OLAP
- Types of OLAP
- ROLAP
- MOLAP
- HOLAP
- DOLAP
- DDE Triplet
- Reporting Architecture
- Database Layer
- Interface Layer
- Server Layer
- Presentation layer
- BI Server Systems
- BI Client Systems and Functionalities
- Hieracheis
- Need of Hierarchies in Reporting
- Need for ODS in Data Warehousing
Informatica
( Week 5 )
- Informatica Concepts
- Basic Concepts
- Key Terms
- Product Architecture
- Various Tools and thier roles
- Power Center vs Power Mart
- Informatica Server Configuration
- Informatica Designer
- Basic Concepts
- Using the Designer
- Working With Sources
- Working with Flat Files, Targets
- Mappings, Transformations, Mapplets
- Working with Debugger
- Implementing Type I , Type 2 , Type 3 mappings
- Loading the Data into different Fact Tables
- Transformations
- Aggregator Transformations
- XML Transformations
- Expression
- Filter
- Joiner
- Loook up Transformations
- Rank, Router
- Sequence Generator
- Sorter Transformation
- Source Qualifier Transformation
- Stored Procedure Transformation
- Transaction Control Transformation
- Union Transformation
- Update Stretegy Transformation
- Connected vs Unconnected Transformations
Informatica
( Week 6 )
- Workflow
- Understanding the Server Architecture
- Working with Workflows
- Working with task assignment, command, decision, control, eventraise, event wait, timer, email, session task
- working with work ltes
- working with sessions
- understanding commit points
- recovering data
- monitoring workflows
- using multiple servers
- log files
- row error logging
- session parameters
- using incremental aggregation
- Other Implementation Considerations
- Understanding the Server Architecture
- Working with Workflows
- Working with task assignment, command, decision, control, eventraise, event wait, timer, email, session task
- working with work ltes
- working with sessions
- understanding commit points
- recovering data
- monitoring workflows
- using multiple servers
- log files
Hi
I have few questions. May be I need to call you ?
1. You have given 6 weeks as per Table of Contents. You also said that the # of hours for the course is 40 hours. I am confused here. Does it mean 40 hours per week * 6 = Total of 240 hours OR does it mean approximately 7 hours per week and the course goes for 6 weeks making it approximately 40 hours ?
2. Is the cost $600 for the complete course ?
3. Is the course available online ? How do we get to practice ?
4. Do you provide job assistance / assistance for certification preparation ?
Thanks
Nags ( nagu_career@yahoo.com )
how many tools informatica or data warehousing, i don’t know exactly. plz tell me is the part of data warehouse or not.if not plz explain me what is.
can you also configure the software for $600 is it included in the package…
Is the Informatica Training affiliated with SAP? and does it carry the same distinction?
Informatica training is totally different from SAP. NO relation between the two.
Do you provide online informatica training? What is the cost of Online Training?
Are you accredited with any educational institution/
NO. we are not. We are an independent entity
What is the cost of training for Informatica
Is it online ?
Regards
Danny Padilla
The price of Informatica Training is $600. The duration of the training is 35 to 40 hours which includes all the concepts discussed on this page in the Table of Contents Section. Please call us to know more.
Greetings I stumbled upon your webpage by mistake when i searched Live search for this subject, I need to tell you your website is quite useful I also like the theme, it is superb!
Thank you Natascha for your kind words. This section has just started. We are yet to post the full course content. The actual course content is available at Informatica Training. I tried to visit your website.