Subscribe and Access : 5200+ FREE Videos and 21+ Subjects Like CRT, SoftSkills, JAVA, Hadoop, Microsoft .NET, Testing Tools etc..

Batch Date: July 20th @ 8:00PM

Faculty: Mr. Suresh

Duration : 30 Days

Venue :
DURGA SOFTWARE SOLUTIONS at Maitrivanam
Plot No : 202, IInd Floor ,
HUDA Maitrivanam,
Ameerpet, Hyderabad-500038.

Ph.No: +91 - 9246212143, 80 96 96 96 96

Syllabus:

 

DATA WAREHOUSING FUNDAMENTALS:

• What is RDBMS
• Features of RDBMS
• What is Data warehousing
• Architecture of datawarehousing
• Difference between RDBMS & DATAWAREHOUSE DATABASES.
• Definitions
• ETL Process
• Reporting
• Types of Tables in D/W
• Types of FACTS tables
• Types of DIMENSION tables
• Types of Schemas in D/W
• What is Data Mart
• Warehouse Approaches

INFORMATICA

• Definitions
• Informatica Tools
• Informatica Architecture
• Types of ports
• Predefined functions
• Types of Transformations
• Source Qualifier T/r
• Expression T/r
• Filter T/r
• Router T/r
• Joiner T/r
• Union T/r
• Rank T/r
• Sorter T/r
• Aggregator T/r
• Connected Lookup T/r
• Unconnected Lookup T/r
• Connected Stored Procedure T/r
• Unconnected Stored Procedure T/r
• Normalizer T/r
• Sql T/r
• Transaction Control T/r
• Xml T/r
• Using Source Tables
• Using Source Flat Files
• SCD1 Mapping
• SCD2 Mapping
• SCD3 Mapping
• Mapplets
• Mapping Parameters
• Mapping Variables
• File List
• Dynamic Connections
• Session Variables
• Parameter files
• Workflow Tasks:
• Start Task
• Session Task
• Event Wait Task
• Event Raise Task
• Email Task
• Decision Task
• Assignment Task
• Control Task
• Command Task
• Timer Task
• Session Properties
• Worklet
• Types of Caches
• Types of Partitions