Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Informatica

No Reviews Yet

Course type: Online Instructor led Course

Platform: Google hangout

Course ID: 10874

Course type: Online Instructor led Course

Platform: Google hangout

Students Interested 2 (Seats Left 0)

₹ 10,000

No Reviews Yet

Date and Time

Not decided yet.

Lakshmi Venkateswaran picture
Lakshmi Venkateswaran

BE Information Science

About Lakshmi Venkateswaran

4+ years of IT and training exp in DW-BI tools
No reviews currently

About the Course

The ETL Tool

Topics Covered

Informatica 8.6
Introduction Informatica and Architectural Overview
Repository Topics
·        Repository Server 8.6 and Agent
·        Repository maintenance
·        Security, repository privileges, and folder permissions
·        Arch of Informatica 8.6
·        Tools Information
·        Domain & Node Config
Source Object Definitions
·        Source types (RDBMS[Oracle],TEXT,XML)
·        Source properties
Target Object Definitions
·        Target types (RDBMS[Oracle],TEXT)
·        Target properties
Transformation Concepts
·        Transformation types and views
·        Transformation features and ports
Mappings
·        Mapping components
·        Source Qualifier transformation
·        Mapping validation
·        Data flow rules
Session Tasks
·        Session Task properties
·        Session components
Workflows
·        Workflow Tools
·        Workflow structure and configuration
·        Workflow Connections
·        Workflow Tasks
·        Workflow Design and properties
Workflow Monitoring
·        Workflow Monitor views
·        Monitoring a Server
·        Actions initiated from the Workflow Monitor
·        Filtering views
Filter transformation
·        Filter properties
Expression transformation
·        Expression properties
·        IN, OUT, Variable Ports
Source Qualifier transformation
·        Source Filter properties
Router transformation(Multi Targets)
·        Group properties
·        Group Based Filters
Joiner transformation
·        Joiner properties
·        Homogeneous Sources
·        Heterogeneous Sources
·        Performance Issues
·        Source Qualifier Based Joins
Working with Parameters
·        Mapping Variables
Target Load Plan
Using XML As Source
Rank transformation
·        Rank properties
Sequence Generator transformation
·        SG properties
Aggregator transformation
·        Aggregation properties
Transformation Developer
·        Tips for using the Transformation Developer(Re-Use Transformation)
Mapplets
·        Creating & Maintaining
·        Parameterised Mapplets
Lookup transformation
·        Lookup principles
·        Lookup properties
·        Connected & Un-Connected
Update Strategy transformation
·        Update Strategy expressions
·        Smart aggregation
·        Refresh strategies
Working with Session Properties
·        Creating using Task Developer
·        Creating using Workflow Designer
Workflow Process Management
Concurrent and sequential Workflows
·        Concurrent Workflows
·        Sequential Workflows
·        Stopping, starting, and suspending tasks and workflows
Workflow Objects
·        Link
·        Decision
·        Event Wait
·        Event Raise
·        Control
·        Command
·        Email
·        Worklets
·        Scheduling
Intro to Slowly Changing Dimesions(SCD)
·        Type 1, Type 2, Type 3
Summary & Conclusion
·        Repository Backup & Restoring

Who should attend

People interested in pursuing a career in DW-BI

Pre-requisites

Basic Understanding of SQL and datawarehousing

What you need to bring

Softwares Installed

Key Takeaways

Good Understanding of ETL tool

Reviews

No reviews currently

Discussions

Students Interested 2 (Seats Left 0)

₹ 10,000

Post your requirement and let us connect you with best possible matches for Computer Software Classes Post your requirement now
₹ 10,000 Enquire