Informatica Training in Chennai,TamilNadu,India

Informatica Training in Chennai has opened up doors for better career

Informatica is one of the most used ETL tools, that is used to create data warehouse for quality date integration which in turn results in better and smooth business functioning. Here, ETL stands for Extract, Transform and Load. To meet the demands of the students, VKV Technologies have come along with the quality Informatica training in Chennai that ensures detailed training from the experienced faculties and placement assistance, as soon as the course gets over. The Informatica tool is specifically used to extract the source data from a system to load it to another after applying the changes needed. Numerous advantages of data warehousing is adhered with this software. This software helps in adopting the changing business needs with quality data warehousing. VKV Technologies, the best Informatica training institute in Chennai has make it sure that students gets the right training at the most affordable rate. With each passing day, more numbers of companies are adapting Informatica for the betterment of their business, which sets the right time for the students to enrol in the course. It is mandatory for the students to have a bachelor’s degree in any discipline to get enrolled in the course

Informatica Architecture

About The Trainer

An INFORMATICA professional with about 9 years of extensive experience on data warehousing projects from medium to large scale. Been actively involved in INFORMATICA corporate training, Freelance training, Online training, Classroom training within and outside my organizations for past 6+ years. WEAM is an initiative to provide high quality training on Informatica domain one on one basis. Priority is to give proper training.

Given 2 week INFORMATICA training in MNC Company.
Worked as INFORMATICA trainer at Private institutes in New Delhi (Applied Labs).
Have provided 5 day corporate trainings in GOOD organizations
Provided training of 4 days to client team at MNC.
Involved in Online Training for Informatica.

Course Objectives

Understand and identify different Informatica Products
Describe Informatica PowerCenter architecture & its different components
Use PowerCenter 9.x components to build Mappings, Tasks, Workflows
Describe the basic and advanced features functionalities of PowerCenter 9.X transformations
Understand Workflow Task and job handling
Describe Mapping Parameter and Variables
Perform debugging, troubleshooting, error handling and recovery
Learn to calculate cache requirement and implement session cache
Execute performance tuning and Optimization
Recognize and explain the functionalities of the Repository Manager tool.
Identify how to handle services in the Administration Console
Understand techniques of SCD, XML Processing, Partitioning, Constraint based loading and Incremental Aggregation
Gain insight on ETL best practices using Informatica

Who should go for this course?

Software Developers
Analytics Professionals
BI/ETL/DW Professionals
Mainframe developers and Architects
Individual Contributors in the field of Enterprise Business Intelligence

Why learn Informatica?

Informatica provides the market's leading data integration platform. Tested on nearly 400,000 combinations of platforms and applications, the data integration platform inter operates with the broadest possible range of disparate standards, systems, and applications. This unbiased and universal view makes Informatica unique in today's market as a leader in the data integration platform. It also makes Informatica the ideal strategic platform for companies looking to solve data integration issues of any size.

What are the pre-requisites for this Course?

Informatica Training Course Outline

Analytic SQL for Informatica
Data Warehousing Concepts
Informatica PowerCenter 9.5.1
Unix Shell Scripting
Business Intelligence

Datawarehousing Concepts

What is DWH?
Characteristics of Datawarehouse
Difference between OLTP and DWH
Architecture of DWH
Various BI tools
Types of DWH
Types of Dimensional Data Modeling
Surrogate key
Types of Dimension

Informatica Architecture

Informatica Power Center Client Tools
Repository Manager
Manage Folders
Designer
Source Analyzer
Target Designer
Mapping Designer
Workflow Manager
Task Developer
Workflow Designer
Workflow Monitor
Workflow Log
Session Log
Types of View

Transformation Basics

Classification
Types of Ports
Data Types

Types of Transformations

Source Qualifier Transformation
Creating Simple Pass through Mapping
Apply Various Filter Conditions
Specify sorted ports
Eliminate Duplicate Values
Creating Custom SQL Query
Joining two or more tables

Filter Transformation

Compare with Source Filter
Types of Tracing Level
Types of Flatfiles
File Import Wizard
Load data from Flat File to Database
Load data from Database to Flat File

Sorter Transformation

Types of Ports
Multiple Sorting

Joiner Transformation

Joining two heterogeneous sources
Types of Joins
Sorted input option

Rank Transformation

Types of Ports
Rank Index
Rank and Dense rank

Sequence Generator

cycle option
Usage of Reset

Expression Transformation

Use of Expression
Usage of Variable Port
IIF and Decode functions

Aggregator Transformation

Informatica aggregate functions
Sorted input option

Router Transformation

Types of Groups
Group Conditions

Union Transformation

Types of Groups

Normalizer Transformation

Types of Normalizer
Transpose Columns to Rows
Default Output Ports

Lookup Transformation

Connected Vs Unconnected Lookups
Unconnected Procedure
Lookup Caches

Stored Procedure Transformation

Create a Sample Procedure
DBA Script

Update Strategy Transformation

Create a Sample Procedure
DBA Script

Transaction control Transformation

Dynamic File Generation

Slowly Growing Dimension

Slowly changing Dimension

Type 1
Type 2
Type 3

Transformation Developer

Create a Reusable Transformation
Promoting Transformations

Mapplet Designer

Create a reusable Mappings

Mapping Parameters

Create a reusable Mappings

Mapping Variables

Create a reusable Mappings

Session variables

Setting Connections
Workflow variables

File Repository Concepts

Indirect loading

Target Load Plan

Types of scheduling
Time-based schedule
Event -based schedule

Mapping Migration Process

Copy from Folder
Import and Export

Analytic SQL for Informatica Training in Chennai

Course Objectives, Course Agenda and Class Account Information
Describe the Schemas and Appendices used in the Lesson
Overview of SQL*Plus Environment
Overview of SQL Developer
Overview of Analytic SQL
Oracle Database SQL and Data Warehousing Documentation

Data Using SQL Grouping and Aggregating

Generating Reports by Grouping Related Data
Review of Group Functions
Reviewing GROUP BY and HAVING Clause
Using the ROLLUP and CUBE Operators
Using the GROUPING Function
Working with GROUPING SET Operators and Composite Columns
Using Concatenated Groupings with Example

Hierarchical Retrieval

Using Hierarchical Queries
Sample Data from the EMPLOYEES Table
Natural Tree Structure
Hierarchical Queries: Syntax
Walking the Tree: Specifying the Starting Point
Walking the Tree: Specifying the Direction of the Query
Using the WITH Clause
Hierarchical Query Example: Using the CONNECT BY Clause

Working with Regular Expressions

Introducing Regular Expressions
Using the Regular Expressions Functions and Conditions in SQL and PL/SQL
Introducing Metacharacters
Using Metacharacters with Regular Expressions
Regular Expressions Functions and Conditions: Syntax
Performing a Basic Search Using the REGEXP_LIKE Condition
Finding Patterns Using the REGEXP_INSTR Function
Extracting Substrings Using the REGEXP_SUBSTR Function

Analyzing and Reporting Data Using SQL

Overview of SQL for Analysis and Reporting Functions
Using Analytic Functions
Using the Ranking Functions
Using Reporting Functions

Performing Pivoting and Unpivoting Operations

Performing Pivoting Operations
Using the PIVOT and UNPIVOT Clauses
Pivoting on the QUARTER Column: Conceptual Example
Performing Unpivoting Operations
Using the UNPIVOT Clause Columns in an UNPIVOT Operation
Creating a New Pivot Table: Example

Pattern Matching using SQL

Row Pattern Navigation Operations
Handling Empty Matches or Unmatched Rows
Excluding Portions of the Pattern from the Output
Expressing All Permutations
Rules and Restrictions in Pattern Matching
Examples of Pattern Matching

Modeling Data Using SQL

Using the MODEL clause
Demonstrating Cell and Range References
Using the CV Function
Using FOR Construct with IN List Operator, incremental values and Subqueries
Using Analytic Functions in the SQL MODEL Clause
Distinguishing Missing Cells from NULLs
Using the UPDATE, UPSERT and UPSERT ALL Options

UNIX Shell Scripting for Informatica Training

Unix Command Review

Basic Unix commands
General commands
File and directory handling commands
Filename generation characters
I/O Redirection features
Other commands

Getting Started

What is a shell script?
Development guidelines
Creating and editing shell scripts
Naming and storing shell scripts
Executing shell scripts
Exercise: Write a simple shell script

Using Variables

Environment variables
Local variables
Assigning values to variables
Assessing variable values
Using quotes
Delimiting variable names
Echo control sequences
Exercise: Add variables to a script

Integer Arithmetic

Using the expr command
Using the (( )) notation
Exercise: Add integer arithmetic to a shell script

Handling Run Time Data

The read command
Command line arguments
Exercise: Writing a generic shell script
Exercise: Writing an interactive shell script

Condition Execution

The if statement
The test command
Other test notations
Default and substitute variables
Exit status codes
Exercise: Adding validation to previous scripts

Loop Constructs

The while loop
The until loop
The for loop
The while true and until false loops
Loop control commands
Exercise: Enhancing the previously written scripts
Exercise: Writing a guess-the-number game

Multi-Branch Decisions

The case statement
Menu driven applications
Exercise: Developing and writing a menu system

Functions

What is a function?
Syntax
Examples
Exercise: Add a function to a script

Interrupt Handling

Interrupt signals
Trapping interrupts
Exercise: Adding traps to the menu script

Additional Features and Facilities

The exec commands
The includes notation
More about loops
Arrays
Here Documents
Exercise: Create a here script

Course Features & Benefits:-

The exec commands
The includes notation
More about loops
Arrays
Here Documents
Exercise: Create a here script

VKV Training Benefits

Training by Real Time Professionals
Project Oriented Training
Running Notes
Flexible Timings
Excellent Lab Facility
Small Training Batch
Certification Support

Our course content is designed in such a way that it is suitable to the beginners as well as the professionals who would like to update themselves with the new technologies. Our trainers will provide you the hands on experience on the real time projects.

Please call VKV Technologies 8489848461

Other Courses From VKV Technologies

.NET

JAVA

ORACLE

TESTING

OTHERS

What Students Says about VKV?

I joined Oracle DBA classes at VKV technologies Medavakkam Jan/2015 month . I felt the trainer Bala , who took Oracle DBA for me was eluded with high knowledge . thereby I developed my skills in Oracle DBA .Thanks to VKV technologies Medavakkam and Bala sir

- Ganapathy Subramanian

I have completed oracle training in VKV Technologies medavakkam chennai which is near from OMR Road and shollinganallore.There coaching was very good with practical approach and there fees is very controlled manner i just refer many of my frds too ,if you want to do oracle sql or pl/sql or oracle dba or oracle rac just refer them they are giving guidance to IT live projects.best oracle institute with real time working professionals in chennai.

- Vinoth Thangaraju

I have taken oracle DBA and RAC Training from VKV Technologies Ltd. The training was Excellent.Thanks for VKV Technologies Ltd. Team.

- Chokkalingam

I have completed oracle course in VKV Technologies. Now i got job good mnc company.really thanks to them.

- anbalahan mariappan

I have completed RAC,DATAGUARD,ASM concepts with real time experience in VKV Technologies at very low cost. They also assisted me in doing the OCA/OCP certification and Documents,softwares were also provided . I am really grateful to the VKV technologies for making more Knowledgeable .

- Gopal G

Good institute for Oracle Administration. Value for money. It's real good for advanced concepts like ASM,Dataguard,RAC.

- sai krishna Madamala

I have taken SQL/PLSQL training in VKV technologies, I am extremely satisfied with trainer and infrastructure, trainer who had very good experience and he trained me in real time scenario, I got learning documents and assignments which are very help full to me to get on interview, thanks a lot VKV technologies.....

- Suryavamshi Nagorao

I had taken ORACLE DBA training in vkv technologies .It is very good experience and i got real time knowledge not only in ORACLE DBA ,But also understanding the ex poser in linux and shell scripting .i have leart about various versions of oracle (9i,10g,11g,12c).Iam confident that ill be placed as an ORACLE DATABASE ADMINSTRATOR.

- anand kumar

I have taken Oracle DBA training from VKV Technology and the training was very good. It was really a good platform where i had real time experience and exposure. VKV Technology has good environment for learning, effective training by real time resources and lab facility. They also helped me to complete my 11g OCP certification.