| |
 |
Introduction to data warehousing |
| |
|
Data warehousing architecture |
| |
|
Databases and warehousing |
| |
|
Tools used in Data warehousing |
| |
|
Basic SQL |
| |
|
Basics of data modeling and dimensional modeling |
| |
|
Introduction to OLTP systems |
| |
|
Introduction to OLAP systems |
| |
|
Introduction to ETL Tools |
| |
|
| |
Informatica (ETL TOOL) |
| |
|
Repository manager |
| |
|
Creating repositories, adding repositories, back up of repositories |
| |
|
Creating Folders, managing folders, managing users |
| |
|
Designer |
| |
|
Working with Transformations (filters, router, expression, sequence generator, look up, update strategy, flat files etc….) |
| |
|
Working with Mappings and Mapplets |
| |
|
Transformation developer |
| |
|
Slowly changing dimensions |
| |
|
Slowly changing targets |
| |
|
Working with cubes, dimensions, levels and hierarchies. |
| |
|
Server manager |
| |
|
Configuration of server to client, creating sessions, mapping sessions, running sessions etc….. |
| |
|
|
| |
Erwin (Data/dimension modeling tool) |
| |
|
Working with logical and physical models |
| |
|
Creating logical modeling |
| |
|
Forward engineering |
| |
|
Reverse engineering |
| |
|
Re-engineering |
| |
|
|
| |
Congos (BI Tool) |
| |
|
Introduction to business intelligence |
| |
|
Working with impromptu administrator |
| |
|
Creating simple reports |
| |
|
Creating cross tab reports |
| |
|
Creating other type of reports |
| |
|
