Informatica Online Beginner level by Feria IT Solutions

INFORMATICA
Introduction to Data Warehousing

What is Data Warehousing?
Who needs Data Warehouse?
Why Data Warehouse is required?
What is difference between Database & Data Warehouse?
Types of systems
1 .OLTP
2. OLAP
Maintenance of Data Warehouse
Data Warehousing Life Cycle

Data Warehouse Architecture

Source
Integration Layer
Staging Area
Targets
ODS

Different types of Data Warehouse Approaches

1. Top-Down Approach
2. Bottom-Down Approach
3. Difference between Top-Down & Bottom-Down Approach
4. Definition of Data Mart
5. Different types of Data marts
6. Difference between Data mart & Data warehouse

Data Modelling

What is Data Modelling?
Different types of Data Model lings
What is Dimension?
1. E-R Modelling
2. Dimensional Modelling
Different types of Dimensional Modelling
1. Star Schema
2. Snow flake schema
3. Galaxy schema
What is Fact?
What is Granularity?
Types of fact?
1. Additive fact
2. Semi additive fact
3. Non additive fact
4. Fact less Fact Table
Types of Dimensions?
1. Confirmed Dimension
2. Junk Dimension
3. Dirty Dimension
4. Degenerative Dimension
Introduction To Informatica
Introduction to Informatica
Architecture of Informatica
Informatica Client tools
1. Informatica power centre Repository
2. Informatica power centre Designer
3. Informatica power centre WORKFLOW DESIGNER
4. Informatica power centre WORKFLOW MONITOR
ODBC Connections of Informatica

Power centre Designer Tools
1. Source Analyser
2. Target Designer
3. Transformation Developer
4. Mapping Designer
5. Mapplet Designer
Types of Transformations

1. Source Qualifier Transformation
2. Filter Transformation
3. Joiner Transformation
4. Expression Transformation
5. Sorter Transformation
6. Aggregator Transformation
7. Rank Transformation
8. Union Transformation
9. Router Transformation
10. Sequence Generator
11. Lookup Transformation
12. Update strategy Transformation
13. Normaliser Transformation
14. Stored Procedure Transformation
15. Transaction Control Transformation

Implementation of Slowly Changing Dimensions (SCD)
1. Implementing SCD TYPE-1
2. Implementing SCD Type-2
3. Implementing SCD Type-3

Informatica Workflow Manager
1. Task
2. Workflow
3. Worklet
4. Workflow Task

Scheduling Workflows
Batch Processing

Informatica Advanced Topics
Implementing Mapplet
User-Defined Functions
Debugging
Mapping Parameters
Mapping Variables
Cache
Target Load Plan
Implementing Worklet
Session Properties
Test Cases
Running the workflow By using PMCMD & PMREP
Conversion of STRINGS to Date Data type
Link-Conditions