Informatica Administration Online Training

[Raj2011]

Dear Students

I am providing INFORMATICA ADMINISTRATION ONLINE TRAINING.

The duration of the course is 20 hrs.
The fee for the course is 12000 INR.

Interested candidats can plz reach me at : [email protected] for futher details and demo session.

Here is the course curriculum :

Informatica 8.6.2
-------------------

- Informatica Architecture 8.6
- Domain Description
- Master Node Description
- Worker Node or child node Description
- Node Description
- Grid Description
- Server componet
- Client componet
- Instalisation of Informatica
----------------------------------
- Instalisation of server :-
- Instalisation of Domain
- Instalisation of Node i.e. master node and child node
- Creation of Grid
- Creation of Repository
- Creation of Repository service
- Creation of Integration service
- Creation of multiple integration service for one Repository.
- Creation of multiple repository i.e. for dev, QA, Production.
- Moving the code from one folder to other folder.
- Deployement group
- How to move the code to deployment group.
- How to move one dev repository content to QA and to Production
- Check in and check out
- Level

Repository Backup
--------------------

- How to take the repository backup
- How to restore the repository metadata

The main concepts related to course will cover in ur course.

=====================

scd1 with date
scd2 with date
scd3 with date
scd3 with date

Partition in informatica
How to increse the performance
like lookup , drop index, create index, dynamic lookup cache
==============================


Data Warehouse Concepts:

Introduction to Data warehouse
What is Data warehouse and why we need Data warehouse
Different types of OLTP systems.
OLTP vs ODS vs Data warehouse
Dimensional modeling
Star schema/Snowflake schema/Galaxy schema
Dimensions / Facts tables.
Slowly Changing Dimensions and its types.
Data Staging Area
Data Marts.
Different types of Dimensions and Facts.
Data Mart vs Data warehouse
DWH Approaches: Ralph Kimball’s vs Bill Inmon’s
Extraction
Transformation
Loading, Diff types of Load in Dwh
Intitial Load and Incrmental Load.
Different Activites in Staging Area.
Data Merging, Data Scrubbing, Data Cleansing, Data Aggregation.
Time Variant, Nonvolatile, Integrated, Subject Oriented.

Slowly changing Dimension
SCD Type1, SCD Type2, SCD Type3.
Degenerate Dimension
Rapidly Changing Dimension.
Rapidly Growing Dimension.
Surrogate Key.
Need of Surrogate key in the dwh project.
Fact Table, Factless fact table.
Zunc Dimension.
Metadata
Data, Information.
Detail Level Fact , Summary Fact or Aggregate Fact.
Snapshot.

Thanks
Raj
Ph : 91-9660567626(M)