cssadhar Posted September 24, 2014 Report Share Posted September 24, 2014 Data Ware Housing Concepts Introduction to Data Warehousing Introduction to OLTP ETL and OLAP Systems Dimensional Modelling Types of Schema’s Types of Fact and Dimension Tables Why do we Need ETL tools What is Informatica? Power Centre Components Informatica Architecture Designer Repository Manager Workflow Manager Workflow Monitor Informatica Concepts and Overview Source Qualifier Target Designer Transformations Mappings & Mapplets Sessions Workflows & Work lets Tasks Sources Working with Relational Sources Working with Flat Files (Direct/Indirect) Targets Working with Relational Targets Working with Flat file Targets Transformations Active and Passive Transformations Connected and Unconnected Transformations Reusable, Non Reusable & Shortcuts Expression Source Qualifier Filter Joiner Sorter Rank Router Union Aggregator Sequence Generator Lookup Stored Procedure Update Strategy Normaliser SQL Transformation Transaction Control Mapplet input and Output transformation Implementation of Slowly Changing Dimensions Type-1 Type-2 Type-3 Cache concepts (Lookup, Aggregator, Joiner, Sorter) Tasks Start Session Assignment Event raise and Event wait Email Command Decision Timer Control Advanced features Incremental Aggregation Mapplet Implementation Target Load Plan Target update override Constraint Based loading Mapping Parameters & Variables Session Parameters Link Conditions Performance Tuning Real Time scenarios & FAQ’s. Contact Us:309-200-3848 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.