|
Introduction To INFORMATICA Training
|
|
INFORMATICA Training Overview
|
INFORMATICA Training Class Goals
- Learn The basic DAta Warehousing Concepts
- Learn the installation of Sql Server 2005
- Learn the differences between SSIS,SSAS,SSRS
- Learn to create Data Packages using SSIS
- Learn different Transformations
- Learn to create Cube,Dimension and Fact using SSAS
- Learn to Analyse Data with different view
- Learn to create different format Reports
- Learn to preview and deploy Report
|
INFORMATICA Courseware
- Data Warehousing Introduction
-
- Basic Concepts
- Views AND Dimensio
- Fact Data Overview
- INFORMATICA Introduction
-
- Intro To ETL
- Informatica Integration Service Architecture Overview
- INFORMATICA Corporation Products
- SQL SERVER 2005 Management Studio Database
-
- Introduction
- Data Manipulation Language(DML)
- Data Control Language(DCL)
- Triggers
- Cursors
- Functions
- Views
- Synonyms
- INFORMATICA Power Center Client
-
- Introduction To ETL
- Introduction To POWER CENTER CIENT
- Types Of CLIENT Tools
-
- Repository Manager
- Designer
- Workflow Manager
- Workflow Monitor
- Power Center Tools
-
- Introduction To Designer
- Introduction To Workflow Manager
- Workflow Monitor
- Importing data from different sources like Oracle,flat File,Management Studio,Excel
- Conclusion
- Transformation Basic Concepts
-
- Data Integration Concepts
-
- Source Qualifier,Reusable Transformation,Debugger,Detail Review of the Expression,Filter
- Sorter, Aggregator , Joiner, Lookup, Update Strategy,
- Router and Sequence Generator Transformations, Source and Target Overrides
- Parameters and Variables ,Self-Join ,Incremental Aggregation ,Dynamic Lookup Cache
- Slowly Changing Dimension ,Audit ,Character Map ,Conditional Split ,Copy Column
- Data Conversion ,Derived Column. ,Export Column ,Look Up ,Fuzzy Look Up ,Merge
- Merge Join ,Row Count
- Import/Export Of Data
-
- From Management Studio To ORACLE,FLAT FILE,EXCEL AND VICE VERSA
- FRrom EXCEL TO DB2 AND VICE VERSA
- Mapping Designer
-
- Create Mappings
- Advance Mapping Techniques
- Error Handling
- Performance Tuning
- Stored Procedures And Custom Transformation
- Repository Reporting
- Partitions
- Conclusion
- Workflow Manager
-
- Create Workflow
- Advance Workflow Techniques
- Conclusion
- Working With Transformation
-
- Expression Transformation
- Working Mapplets
- LookUp Transformation
- Conclusion
- Creating Cubes And Dimensions
-
- Create Dimension
- Working Mapplets
- Create Cubes
- Conclusion
- Advance Mapping Techniques
-
- Advance Workflow Techniques;
- Error Handling
- Performance Tuning
- Stored Procedures and Custom Transformations Repository Reporting; Partitions
- Conclusion
|
|
|
I got the opportunity of getting a practical experience on SAS couse from InfoSchool. It helped me in learning new analytical tools and their applications, today I am in my dream job. Thanks to InfoSchool for giving this opportunity.
By Vidya,
SAS Developer, PowerSoft Technologies,
|
|
|