Training Enquiry

Informatica Training


Course Name : Informatica                                                                    24*7 Technical Support
Duration         : 35 hours
Faculty            : Realtime experience

           Sun trainings is a best online center in Hyderabad. We are providing very best online training on Informatica.

Highlights in our training:

*  Very in depth course material with real time scenarios.
*  We are providing class with highly qualified trainer.
*  We will provide class and demo session at student flexible timings.
*  In training case studies and real time scenarios covered.
*  We will give 24*7 technical supports.
*  Each topic coverage with real time solutions.
*  We are providing normal track,weekend,fast track classes.
*  We will give every recorded session for play later.
*  We are giving placement support by multiple consultancies in INDIA, USA, Australia, UK etc.
*  We are providing certification oriented trainings with 100% pass guarantee.
*  We will give full support while attending the interviews and contact me any time after completion of the course.

Course Content:

INTRODUCTION

SQL, PL/SQL Basics, Data Warehouse, Informatica and UNIX Training Syllabus Plan TRAINING AGENDA

1. SQL
2. PL /SQL Basics
3. Toad and SQL Developer Tools
4. Data Warehouse
5. Informatica Power Center 9.6
6. Unit Testing
7. Deployment activities
8. Unix Basics and Shell scripting
9. Real-time Projects
SQL

Introduction

Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Retrieval Language (DRL)
Transaction Control Language (TCL)
Data Control Language (DCL)

Data Types

Conditional Selections and Operations

Where
Order by

Operators

Arithmetic operators
Comparison operators
Logical operators

Arithmetic operators
+, -, *, /
Comparison operators
=, !=, >, <, >=, <=, <>
Between not between
in, not in
null, not null
like
Logical operators
And
Or
Not

USING ALIASES

FUNCTIONS

Single row functions

a. Numeric functions
b. String functions
c. Date functions
d. Miscellaneous functions
e. Conversion functions

Group functions

a. Sum
b. Avg
c. Max
d. Min
e. Count

CONSTRAINTS

Domain integrity constraints
a. Not null
b. Check

Entity integrity constraints
a. Unique
b. Primary key

Referential integrity constraints
a. Foreign key

USING MERGE
SUBQUERY
DISTINCT
GROUP BY AND HAVING
SET OPERATORS
Difference between ROWID and ROWNUM

EXTERNAL TABLES

Accessing External Table Data
Difference between External and normal tables.

JOINS

Equi join
Non-equi join
Self-join
Natural join
Cross join

Outer join
a. Left outer
b. Right outer
c. Full outer

Inner join


VIEWS

Simple view
Complex view
Inline View

PARTITIONS
Range partitions
List partitions

SUBQUERIES AND EXISTS
Single row sub queries
Multi row sub queries
Multiple sub queries
Correlated sub queries

Brief About INDEXES
Unique index
Non-unique index
Btree index
Bitmap index

QUERY TUNING
Initial Analysis
Run Explain Plan
Create Index
Table analysis
Hints
Partitions

PL/SQL Introduction to PL/SQL

Variables
Constants
Records
Conditional Statements
Procedures
Functions
Parameters-Procedure, Function
Exception Handling

Data Warehouse Introduction

Business Intelligence
Data Warehouse
What is a DataMart
What is the difference between a data warehouse and a Data Mart
OLTP
ODS (Operational Data Sources)
What is Staging area and why we need it in DWH

Schemas

Star schema
Snowflake schema

Dimension and Fact Types of Dimensions
Slowly Changing Dimension( SCD)
a. SCD-Type1– Current Data
b. SCD-Type2 – Historical Data
c. SCD-Type3 – Partial History
Confirm Dimension
Junk Dimension
De Generated Dimension

Types of facts
Additive
Semi-Additive
Non-Additive
Factless Fact Table

Granularity
Data cleansing
Surrogate key
Difference between a primary key and a surrogate key
Top Down approach
Bottom Top approach

ETL – INFORMATICAPOWER CENTER 9.6
Informatica Overview
Power Center
Power Mart
Designer
Workflow Manager
Repository Manager
Integration Services
Repository Services
Integration Service Process (ISP)
Data Transformation Manager (DTM) Process
Session
Workflow
Source Definition
Target Definition

Informatica Installation

Informatica Transformations
Source Qualifier
Filter
Expression
Router
• Session Level UPDATE else INSERT
• Mapping Level UPDATE else INSERT
Update Strategy Transformation
• Mapping level
• Session level
Joiner Transformation

Differences between dynamic lookup and static lookup
Difference between mapping level and session level variables
• Session level variables
• Mapping level variables
Sequence Generator
Normalizer Transformation

Incremental logic or Delta or CDC

• Using parameter file
• Using oracle Control tables
Transaction Control Transformation
Lookup
a. Connected
b. Unconnected

Lookup Caches

• Persistent cache
• Re-cache from lookup source
• Static cache
• Dynamic cache
• Shared cache
Aggregator

Analytical Functions

• First row Function
• Last row Function
Flat Files
• Delimiter
• Fixed Width
List Files

SCD Type-I Update else Insert

SCD Type-II

• Effective-Date Approach
• Flag Approach
• Version Approach

SCD Type-III

Constraint Base Load in Session Level

Parameter Files

Rank Transformation
Stored ProcedureTransformation
Sorter Transformation
Input Transformation
Output Transformation
Union Transformation
SQL Transformation
Java Transformation Overview
XML Generator
XML Parser
Mapplet Input Transformation
Mapplet output Transformation
Some other IMP transformations

• Performance tuning in Informatica
• Informatica Session Log shows busy percentage
• Target Update Override
• Overriding the WHERE Clause
• Difference between 7.x and 8.x and 9.X
• Power Center 9.X Architecture.

Miscellaneous

• Shortcuts
• Recovery
• Session Log
• Debugger
• Worklets
• Active & Passive
• Standard & Reusable
• Scheduling
• Email Task
• Decision Task
• Concurrent Workflows
• Complex Mapping
• Error Handling
• Mapplets
• Code Pages
• Meta Data
• Versioning

Third Party Tools

• Putty
• Edit Plus
• FTP (File Transfer Protocol) – File Zilla

UNIX:: Introduction to the UNIX Operating System

• What is UNIX?
• Files and processes
• The Directory Structure
• Starting an UNIX terminal
• Listing files and directories
• Making Directories
• Changing to a different Directory
• Copying Files
• Moving Files
• Removing Files and directories
• Displaying the contents of a file on the screen
• Searching the contents of a file
• Pipes
• Other Useful UNIX commands

Basics of the VI editor

• Shell script to upload files in Informatica server
• Shell script to transfer files from Informatica server to remote server
• Shell script to load Data
• Shell script to create indicator file
• Shell script to create indicator file
• Some other useful scripts.

UNIT TESTING

Real time standard unit test cases will be explained.

DEPLOYEMENT

Introduction about Deployment
Deployment activities on different DB environments.

REALTIME DATABASE ENVIRONMENTS

Introduction about Database Environments

TEST
DEV
QA
UAT
PROD

PROJECTS Development

 Migration Projects
 New Development or Start up project

Support

 Production Support /Enhancement Project
 24/ 7 Project

2 Real time Projects (Sales & Pharma) will be explain and will share the project documents.