Informatica

Overview of SQL and PLSQL

• Primary,foreign,unique Keys
• Indexing
• Procedure
• Function
• Package
• Cursor (normal And Ref Cursor)
• Trigger (all 12 Combinations With Use)
• View (normal And Materilize View)
• Synonyms
• Aggregate Functions

Data warehousing concepts

• Oltp, Olap ( Along With Real Time System Example )
• Rolap, Molap, Holap
• Fact Dimension
• Star Schema , Snowflake Schema
• Slowly Changing Dimension
• Datawarehouse Key Or Surogate Key
• Actual Use Of Dataware House With Scope In The Analysis Field
• Whole Software Development Life Cycle ( Sdlc )

Informatica

• Introduction To Data Warehousing
• Understanding The Scope Of Data Warehouse Project
• Data Warehouse Architecture And Design
• Informatica And Data Warehousing
• Informatica Architecture
• Informatica Server
• Etl With Informatica
• Informatica Suite Components
• Concept Of Active/ Passive And Connected / Disconnected Transformation
• Informatica Designer
• Workflow Monitor
• Source Analyzer
• Warehouse Designer
• Mapping Designer
• Mapplets Designer
• Creating / Managing The Repository
• Schedulers
• User Management
• Specifying The Database Connections
• Troubleshooting
• File / Folder Access Management
• Backup & Restore