Find
in
Avoid scams by dealing locally! Always exchange items and money in person and Never pay in advance. More info

Informatica online training



Contact Us at: ================================
Phone : +91-8500122107
Email : raj@apex-online-it-training.com
Website : www.apex-online-it-training.
Course Name : Informatica online training
Course Duration : 30 Hours
INFORMATICA
DATAWAREHOUSING CONCEPTS:
INTRODUCTION TO DATAWAREHOUSING
• Data Warehousing Concepts
• Dataware housing (what/Why/How)
• Data Modelling(Schemas, FACTS and DIMENSIONS)
• Slowly Changing Dimensions
• Metadata
PowerCenter Components and User Interface
• PowerCenter Architecture
• PowerCenter Client Tools
• Lab – Using the Designer and Workflow Manager
Source Qualifier
• Source Qualifier Transformation
• Lab Project Overview
• Lab A - Load Payment Staging Table
• Source qualifier Joins
• Lab B - Load Product Staging Table
• Source Pipelines
• Lab C - Load Dealership and Promotions Staging Table and Real time issues
Expression, Filter, File Lists and Workflow Scheduler
• Expression Editor
• Filter Transformation
• File Lists
• Workflow Scheduler
• Lab - Load the Customer Staging Table and Real time issues
Joins, Features and Techniques I
• Joiner Transformation
• Shortcuts
• Lab A - Load Sales Transaction Staging Table
• Lab B - Features and Techniques I and Real time issues
Lookups and Reusable Transformations
• Lookup Transformation
• Reusable Transformations
• Lab A - Load Employee Staging Table
• Lab B - Load Date Staging Table and Real time issues

Debugger
• Debugging Mappings
• Lab - Using the Debugger
Sequence Generator
• Sequence Generator Transformation
• Lab - Load Date Dimension Table and Real time issues

Lookup Caching, More Features and Techniques
• Lookup Caching
• Lab A - Load Promotions Dimension Table
• Lab B - Features and Techniques II
• Review and more Lab Activities and Real time issues
Router, update Strategy and Overrides
• Router Transformation
• Update Strategy Transformation
• Expression Default Values
• Source Qualifier Override
• Target Override
• Session Task Mapping Overrides
• Lab - Load Employee Dimension Table and Real time issues
Dynamic Lookup and Error Logging
• Dynamic Lookup
• Error Logging
• Lab - Load Customer Dimension Table

Unconnected Lookup, Parameters and Variables
• Unconnected Lookup Transformation
• System Variables
• Mapping Parameters and Variables
• Lab - Load Sales Fact Table

Sorter, Aggregator and Self-Join
• Sorter Transformation
• Aggregator Transformation
• Active and Passive Transformations
• Data Concatenation
• Self-Join
• Lab - Reload the Employee Staging Table and Real time issues
SCD type1 - LAB
SCD type2 - LAB
SCD type3 - LAB
Mapplets
• Mapplets
• Lab - Load Product Daily Aggregate Table
• Review and more Lab Activities and Real time issues
Workflow Variables and Tasks
• Link Conditions
• Workflow Variables
• Assignment Task
• Decision Task
• Email Task
• Lab - Load Product Weekly Aggregate Table
More Tasks and Reusability
• Event Raise Task
• Event Wait Task
• Command Task
• Reusable Tasks
• Reusable Session Task
• Reusable Session Configuration
Worklets and More Tasks
• Worklets
• Timer Task
• Control Task
• Lab - Load Inventory Fact Table


FOR FREE DEMO contact us at:
EMail : raj@apex-online-it-training.com
Phone : +91-8500122107
WebSite: www.apex-online-it-training.com



 Respond to this ad


Ad ID: 1256184
Similar ads: