learn well technocraft - classes| courses well technocraft - informatica... · data quality...

Learn Well Technocraft Website: www.dw-learnwell.com Contact: +91 8411002339/+91 7709292162 Email: [email protected]

Classroom | Corporate | Online

Informatica Cloud/ Power Center Syllabus ------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------ Learn Well Technocraft

Informatica Cloud

Getting Started Tutorial

Comparison with Informatica Power Center.

Creating Informatica Cloud Account/login.

Downloading and Installing Informatica Secure Agent.

Architecture of Informatica Cloud

Security Features of Informatica Cloud

Various Services of Informatica Cloud:

o Administrator

Details about Organization

Setting up default email notifications

Adding users to the Organization

Setting up user Roles

Run Time Environment

Downloading secure agent

Adding secure agent under organization

Adding Connections under organization

Working on Add-on Connectors

o Monitor

Activity Log





Restarting a job

View Session log

o Data Integration

Understanding the Data Integration Dashboard

Working on various type of mappings

Integration Mappings

Cleansing Mappings

Warehousing Mappings

o SCD1 mappings wizard



Working on various type of Tasks

o Mapping Task

o Synchronization Task

o Replication Task

o Power Center Task

o Mass Ingestion task

o Integration Tasks

o Cleansing Tasks

o Warehousing Task

Working on various type of Taskflows





Working on Components

Importing Mapplets in Informatica cloud

Working on Connections

o Salesforce Connections

o Database Connections

o Flat File Connections and others

Working on Various Transformation in Cloud

o Sequence

o Joiner

o Sorter

o Filter

o Router

o Expression

o Lookup

o Aggregator

o Mapplet

o Normalizer

o Union

o SQL

Working on Session Properties

o General Option Settings





o Performance Settings

o Advanced

o Error Handling

Working With Parameters

o Defining Local Variables

o Defining Global Variables

Understanding Migration activities

Power Center (Optional and Extra)

Designer Guide:

Using the Designer

o Configuring Designer Options

o Using Toolbars

o Navigating the Workspace

o Designer Tasks

o Viewing Mapplet and Mapplet Reports

Working with Sources

o Working with Relational Sources

o Working with COBOL Sources

o Working with Cobol Source Files





Working with Flat Files

o Importing Flat Files

o Editing Flat Files Definition

o Formatting Flat Files Column

o File Type – Direct/Indirect

Working with Targets (File/Tables)

o Importing Target Definition

o Creating Target Definition from Source Definition

o Creating Target Definition from Transformations

o Creating Target tables

Mappings

o Working with Mappings

o Connecting Mapping Objects

o Linking Ports

o Propagating Port Attributes

o Working with Targets in a Mapping

o Working with Relational Targets in a Mapping

o Validating a Mapping

o Using Workflow Generation Wizard

Mapplets

o Understanding Mapplets Input and Output





o Using Mapplet Designer

o Using Mapplets in Mapping

Mapping Parameters and Variables

Working with User-Defined Functions

Using the Debugger

o Creating Breakpoints

o Configuring the Debugger

o Monitoring the Debugger

o Evaluating Expression

Creating Cubes and Dimensions

Using Mapping Wizard

Naming Conventions

Transformation Guide:

Working with Transformations

o Configuring Transformations

o Working with Ports

o Working with Expressions

o Reusable Transformations

Aggregator Transformation

Custom Transformation





Expression Transformation

External Transformation

Filter Transformation

Joiner Transformation

Java Transformation

Lookup Transformation

Lookup Caches

Normalizer Transformation

Rank Transformation

Router Transformation

Sequence Generator Transformation

Sorter Transformation

Source Qualifier Transformation

SQL Transformation

Stored Procedure Transformation

Transaction Control Transformation

Union Transformation

Update Strategy Transformation

Transformation Language Reference:

The Transformation Language





Constants

Operators

Variables

Dates

Functions

Creating Custom Function

Workflow Basics Guide:

Workflow Manager

o Workflow Manager Options

o Navigating the Workspace

o Working with Repository Objects

o Copying Repository Objects

o Comparing Repository Objects

Workflow and Worklets

o Creating a Workflow

o Using Workflow Wizard

o Assigning an Integration Service

o Working with Worklets

o Working with Links

Sessions





o Creating a Session Task

o Editing a Session

o Pre- and Post- Session Commands

Session Configuration Objects

Tasks

o Creating a Task

o Configuring Tasks

o Working with Command Task

o Working with Decision Task

o Working with Event Task

o Working Timer Task

o Working with Assignment Task

Sources

o Configuring Sources in a Session

o Working with Relational Sources

o Working with Flat Sources

Targets

o Configuring Targets in a Session

o Working with Relational Targets

o Working with File Targets

o Reject Files





Validation

o Validating Tasks

o Validating Worklets

o Validating Session

o Validating Workflows

Scheduling and Running Workflows

o Scheduling a Workflow

o Manually Starting a Workflow

Sending Email

o Working with Email Tasks

o Working with Post-Session Email

Workflow Monitor

o Using Workflow Monitor

o Customizing Workflow Monitor Options

o Working with Tasks and Workflows

o Using Gantt Chart View and Task View

Workflow Monitor Details

o Integration Services Properties

o Workflow Run Properties

o Worklet Run Properties

o Session Task Run Properties





o Performance Details

Session and Workflow Logs

o Log Events

o Log Events Window

o Working with Log Files

o Workflow Logs

Administrator Guide:

Understanding Domains

o Nodes

o Application Services

Using Administration Console

Managing the Domain

o Managing Alerts

o Managing Folders

o Managing Permissions

o Managing Application Services

o Managing the Nodes

Managing Users and Groups

Managing Privileges and Roles

o Domain Privileges





o Repository Services Privileges

o Reporting Service Privileges

o Managing Roles – Assigning Privileges and Roles to Users and Groups

Creating and Configuring the Repository Services

Managing the Repository

Creating and Configuring Integration Services

o Enabling and Disabling the Integration Services

o Running in Normal and Safe Mode

o Configuring the Integration Services Processes

Integration Services Architecture

Creating the Reporting Services

o Managing the Reporting Services

o Configuring the Reporting Services

Managing License

Advanced Workflow Guide:

Understanding Pipeline Partitioning

o Partitioning Attributes

o Dynamic Partitioning

o Partitioning Rules

o Configuring Partitioning





Partitioning Points

o Adding and Deleting Partitioning points

o Partitioning Relational Sources

o Partitioning File Targets

o Partitioning transformations

Partitioning Types

Real Time Processing

Commit Points

Workflow Recovery

Stopping and Aborting

o Error Handling

o Stopping and Aborting Workflows

Concurrent Workflows

Load Balancer

Workflow Variables

o Predefined Workflow Variables

o User- Defined Workflow Variables

o Using Worklet Variables

o Assigning Variable Values in a Worklet

Parameter and variables in Sessions

o Working with Session Parameters





o Assigning Parameter and Variables in a Session

Parameter File

Session Caches

Incremental Aggregation

Session Log Interface

Command Reference:

Using Command Line Programs

o Infacmd

o Infasetup

o Pmcmd

o pmrep

Performance Tuning Guide:

Performance Tuning Overview

Bottlenecks

o Using Thread Statistics

o Target Bottlenecks

o Source Bottlenecks

o Mapping Bottlenecks

o Session Bottlenecks





o System Bottlenecks

Optimizing the Targets

Optimizing the Source

Optimizing the Mapping

Optimizing the Transformations

Optimizing the Sessions

Optimizing the PowerCenter Components

Optimizing the System

Using Pipeline Partitions

Performance Counters

Repository Guide:

Understanding the Repository

Using Repository Manager

Folders

Managing Object Permissions

Working with Versioned Objects

Exporting and Importing Objects

Copying Objects

Note: Lab sessions for all the points mentioned above will be taken.





Data warehousing Syllabus

Evolution of Datawarehousing - History

The need of Datawarehousing

Why Datawarehousing

What is Datawarehousing – The Definition

o Subject -Oriented

o Integrated

o Non – Volatile

o Time Varying

Datawarehousing Architecture

o Data Source Layer

o Data Extraction Layer

o Staging Layer

o ETL Layer

o Data Storage Layer

o Data Logic Layer

o Data Presentation Layer

o Metadata Layer

o System Operation Layer

Dimension table





Fact table

o Additive Facts

o Semi Additive Facts

o Non – Additive Fact

o Cumulative

o Snapshot

Attribute

Hierarchy

Types of Schema

o Star Schema

o Snow Flake Schema

o Fact Constellation Schema

Slow Changing Dimension

o SCD1 – Advantages/ Disadvantages



OLAP and OLTP

- Difference between OLAP and OLTP

- Types Of OLAP

o Multi-Dimensional (MOLAP)

o Relational(ROLAP)





o Hybrid(HOLAP)

learn well technocraft - classes| courses well technocraft - informatica... · data quality...

Documents