Informatica ETL tool
Why ETL tool?
Architecture of Informatica
Introduction to components of Informatica
Designer
Workflow Manager
Repository Manager
Workflow Monitor
Creating ETL jobs using Designer
Designer components
Source Analyzer
Warehouse Designer
Mapping Designer
Transformation Developer
Mapplet designer
Simple jobs
Moving data from database to files
Moving data from files to database
Transformations
What is transformation?
Examples of transformations
Filter
Aggregator
Sorter
Joiner
Source Qualifier
Lookup
Update Strategy
Router
Sequence Generator
Rank
Stored procedure
Monday, March 31, 2008
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment