 |
Introduction to Informatica |
|
What is Datawarehousing? |
|
Datawarehousing - Evolution |
|
Datawarehousing - Characteristics |
|
Datawarehousing - Life Cycle |
|
What is Business Intelligence? |
|
What is RDBMS? |
|
Waterfall and SDLC Methodology |
|
Designer |
|
Workflow Manager |
|
|
Workflow Monitor |
|
Repository Manager |
|
Sample Mapping |
|
Manage Folders and Connections |
|
Options and Toolbars |
|
Export and Import |
|
Source and Targets |
|
Relational Table Import |
|
Flat File Import |
|
XML File Import |
|
|
| Day 2 |
|
|
Transformation types |
|
Source Qualifier |
|
Expression |
|
Comparing with previous record |
|
Sorter |
|
Source Qualifier to join Data |
|
Filter Transformation |
|
|
Expression Transformation |
|
Sequence Generator Transformation |
|
Rank Transformation |
|
Router Transformation |
|
Aggregator Transformation |
|
Joiner Transformation |
|
Aggregator |
|
Debugger |
|
| Day 3 |
|
Flat File Creation |
|
Transforming one record into Multiple |
|
Merging Multiple records into One |
|
Removing Duplicate rows |
|
Constraint Based Loading |
|
Lookups |
|
|
Update strategy |
|
Creating Workflow |
|
Starting Workflow |
|
Monitoring Workflow |
|
Workflow Tasks |
|
| Day 4 |
|
|
Mock Project |
|
Live Project |
|
|
