Informatica's product is a portfolio focused on Data Integration: ETL, Information Lifecycle Management, B2B Data Exchange, Cloud Data Integration, Complex Event Processing, Data Masking, Data Quality, Data Replication, Data Virtualization, Master Data Management, Ultra Messaging;

Topics Covered

Data warehouse Concepts ? What is Datawarehouse ? Definitions of Dataware house ? OLTP and OLAP. ? Dataware house Architecture. ? Data Marts and types. ? Difference between OPERATIONAL DS AND DWH ? Types of Data Extraction ? Data Scrubbing ? Data Aggregation ? Data Merging ? Data Cleansing ? Types of Data loading (SCD’s) ? Top down approach and Bottom up approach ? Star schema and Snow flake schema ? Facts and dimensions ? Granuality ? Types of Dimensions ? Types of fact table ? Types of Facts Informatica Power Center ? Informatica Power center architecture ? Power center components ? Power center Deginer ? Workflow manager ? Work Flow monitor ? Workflow manager ? Repository manager ? Repository ? Integration services ? Power center domain ? Concept of nodes and grid ? Power center administration console. Repository Administration ? Creating Repository Users and Groups . ? Connecting to the Repository. ? Creating a Group ? Assigning Privileges to a Group. VERTEX SOFT DataWarehouse Course Content Page 2 ? Creating a User ? Creating a Folder ? Folder Permissions ? Creating Folders Using the designer ? Creating Source Tables. ? Creating Target Tables ? Creating a Pass-Through Mapping ? Creating source definitions ? Creating a Mapping ? Connecting Transformations ? Mapplets ? Reuseable Transformation ? Creating Shortcuts ? Types of ports ? Target Load Plan ? ETL Naming standards ? Creation of table in database using Deginer. Transformations ? Expression Transformation ? Lookup Transformation ? Sequence Generator Transformation ? Filter Transformation ? Joiner Transformation ? Sorter Transformation ? Router Transformation ? Aggregator Transformation ? Update Strategy Transformation ? Union Transformation ? Rank Transformation ? Transaction Control Transformation ? Normalizer Transformation ? Source Qualifier Transformation ? Stored Procedure Transformation ? Debugging Mappings VERTEX SOFT DataWarehouse Course Content Page 3 Using the workflow manager ? Creating Sessions and Workflows ? Configuring Database Connections in the Workflow Manager ? Creating a Reusable Session ? Creating a Workflow ? Running and Monitoring Workflows ? Opening the Workflow Monitor Workflow Tasks ? Session ? Assignment task ? Link task ? Event raise task ? Event wait task ? Timer task ? Control task ? Decision task ? Email task ? Post session and Pre-session commands ? Session recovery ? Commit points ? Creation of Parameter file ? session parameter ? Mapping Variables and Parameters. ? Worklet ? Performance tuning in ETL Real Time Tasks ? Unit Test cases. ? Preparation of Mapping Technical documents . ? SDLC. ? Real Time interview panel questions while teachings concepts.

Who should attend

Any one who secured any Degree

Pre-requisites

Knowledge on Oracle & SQL

What you need to bring

Nothing

Key Takeaways

Expertises Training methodologies, Builds your confidence Delivers the best quality training.