Informatica Training in Chennai

Greens Technology is a best rated Informatica Training institute in Chennai Tambaram with Placements. Informatica is a powerful data integration tool for ETL Architecture. It provides data integration software for hospitals, industries, telecommunication, financial and various business. Informatica is also used as a data cleansing tool. It offers cloud-based services in all popular platforms. Training in Tambaram offering Informatica Lab Facilities to students. So, students can learn Informatica through practical sessions and clearing doubts on the time.

Informatica Developer roles in Chennai:

• Develop the coding, testing, implementing, debugging and documenting the complex programs.
• Resolving moderate problems associated with the designed programs and provides technical guidance on complex programming.
• Creating proper technical documentation in the work assignments.

Informatica Developer Salary in Chennai:

According to PayScale website, the average salary for an Informatica developer in Chennai is 6,10,319 per year. More than 6 years of experience in this field get 12,34,456 per year.

Informatica Training in Chennai Tambaram:

Training in Tambaram is one of the best Informatica Training Institutes in Chennai. We are focusing Placement based hands-on training for Informatica Course. Our Informatica Trainers are taking the classes from basic level to Advanced Level. Our Students can get the job easily in MNC companies in Chennai and Bangalore once complete their Informatica Classes. Our Informatica Course content and syllabus are revised monthly once by our experienced trainers. Our Informatica training syllabus is designed for fulfilled to our student’s needs. So, you can get the up-to-date technical knowledge in Informatica field. Our 6+ years of experienced trainers are working hard to improve their student knowledge and helps to attend the interviews confidently.

Our Training center offering Informatica Training in various places around the Chennai. We are providing well infrastructure with fully equipped lab facilities to our students. We pay more attention to the needs of our students. Already we have trained more than 200+ Students in Chennai with placement. Informatica Training timing schedule on weekday classes, Weekend classes, Evening classes and Fast track classes. Our Informatica Course fees is based on student’s requirement and value for money. After completing Informatica Classes, providing free resume building classes, Aptitude classes, Mockup Interview Sessions.

Our Informatica Course syllabus covering some important topics like Informatica Power Center Component, Informatica concepts and overview, Sources, Targets, Active and Passive Transformation, Workflow Manager, Indirect Loading, Target Load plan, Worklet, Mapplet, Reusable Transformation, XML Migration, Folder copy, Scheduling workflow, Parameter and Variable, XML Source, Target and Transformation, Performance Tuning,   Informatica real-time project and Informatica placement training in Chennai.

 Informatica Training in Chennai Syllabus

 Informatica Training Course Outline

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

Data warehousing 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 heterogenouse 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

• Database opertations
• Data Driven

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

• Design Parameter File

Mapping Variables

• Set variables function

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

Grouping and Aggregating Data Using SQL

• 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