"Best informatica Training+100% Placement assistance Institute in Bangalore - Bangalore" is no longer available

No Reviews Yet

Koramangala, Bangalore

Course ID: 16601

Koramangala, Bangalore

bavish picture
No Reviews Yet

Date and Time

Not decided yet.

bavish picture


About bavish

7-8 years in industry exeperience
No reviews currently

About the Course

Informatica, the global giant in data warehousing solutions offers data integration tools for enterprise. These programs are a proven solution for enterprises and have set standards for highly scalable and high-performance solutions. Informatica is the market leader in the data integration software and services, working towards solving the problem of data fragmentation across disparate systems, helping organizations gain greater business value from all their information assets. Software Training Lab ,Bangalore,STL along with Informatica offer a unique combination of deep knowledge of the enterprise data integration platform, coupled with stl’s expertise in training software professionals on existing and emerging technologies.

Topics Covered

1.1 Informatica PowerCenter
1.2 Product Overview
1.2.1 PowerCenter Domain
1.2.2 Administration Console
1.2.3 PowerCenter Repository
1.2.4 PowerCenter Client
1.2.5 Repository Service
2.1 Adding a Repository to the Navigator
2.2 Configuring a Domain Connection
2.3 Connecting to a Repository
2.4 Viewing Object Dependencies
2.5 Validating Multiple Objects
2.6 Comparing Repository Objects
2.7 Truncating Workflow and Session Log Entries
2.8 Managing User Connections and Locks
2.9 Managing Users and Groups
2.10 Working with Folders
3.1 Source Analyzer
3.1.1 Working with Relational Sources
3.1.2 Working with Flat Files
3.2 Target Designer
3.3 Mappings
3.4 Transformations
3.4.1 Working with Ports
3.4.2 Using Default Values for Ports
3.4.3 User-Defined Default Values
3.5 Tracing Levels
3.6 Basic First Mapping
3.7 Expression Transformation
3.8 Filter Transformation
3.9 Router Transformation
3.10 Union Transformation
3.11 Sorter Transformation
3.12 Rank Transformation
3.13 Aggregator Transformation
3.14 Joiner Transformation
3.15 Source Qualifier
3.16 Lookup Transformation
3.16.1 Lookup Types
3.16.2 Lookup Transformation Components
3.16.3 Connected Lookup Transformation
3.16.4 Unconnected Lookup Transformation
3.16.5 Lookup Cache Types: Dynamic, Static, Persistent, Shared
3.17 Update Strategy
3.18 Dynamic Lookup Cache Use
3.19 Lookup Query
3.20 Lookup and Update Strategy Examples
Example to Insert and Update without a Primary Key
Example to Insert and Delete based on a condition
3.21 Stored Procedure Transformation
3.21.1 Connected Stored Procedure Transformation
3.21.2 Unconnected Stored Procedure Transformation
3.22 Sequence Generator Transformation
3.23 Mapplets: Mapplet Input and Mapplet Output Transformations
3.24 Normalizer Transformation
3.25 XML Sources Import and usage
3.26 Mapping Wizards
3.26.1 Getting Started
3.26.2 Slowly Changing Dimensions
3.27 Mapping Parameters and Variables
3.28 Parameter File
3.29 Indirect Flat File Loading
4.1 Informatica Architecture
4.1.1 Integration Service Process
4.1.2 Load Balancer
4.1.3 DTM Process
4.1.4 Processing Threads
4.1.5 Code Pages and Data Movement
4.1.6 Output Files and Caches
4.2 Working with Workflows
4.2.1 Assigning an Integration Service
4.2.2 Working with Links
4.2.3 Workflow Variables
4.2.4 Session Parameters
4.3 Working with Tasks
4.3.1 Session Task
4.3.2 Email Task
4.3.3 Command Task
4.3.4 Working with Event Tasks
4.3.5 Timer Task
4.3.6 Decision Task
4.3.7 Control Task
4.3.8 Assignment Task
4.4 Schedulers
4.5 Worklets
4.6 Partitioning
4.6.1 Partitioning Attributes
4.6.2 Partitioning Types
4.6.3 Some Points
4.7 Session Properties
4.8 Workflow Properties


1. Writing Basic SQL SELECT Statements
2. Restricting and Sorting Data
3. Single-Row Functions
4. Displaying Data from Multiple Tables
5. Aggregating Data Using Group Functions
6. Subqueries
7. Manipulating Data
8. Creating and Managing Tables
9. Including Constraints
10. Creating Views
11. Creating Views
12. Using SET Operators
13. Enhancements to the GROUP BY Clause
14. Advanced Subqueries

1. Star and Snow flake Schemas
2. Facts and Dimensions
3. Different Types Of Facts and Dimensions.
4. Difference Between OLTP,ODS,DW and Data Marts.

Who should attend

Informatica has its own transformation langugage that you can use in your expressions, filter and such. It is quite versatile and not at all difficult to learn, if you're familiar with any of the most popular programming languages of today. SQL is probably the one it resembles the most.
You will definitely need to learn at least the basics of this langugage to be able to use Informatica efficiently.


(Good understanding of SQL is pretty much a requirement anyway if you're going to use Informatica (or any ETL tool) - of course this depends on what your source and target systems are.)

It is also possible to create Java transformations, although those should be fairly rarely needed. Usually the built-in transformations combined with Informatica's own transformation language will provide more than enough options.

What you need to bring

reference material regarding informatica

Key Takeaways

Over 35 lectures and 9 hours of content!
Learn Informatica
Learn Power Center
Learning ETL Tools


No reviews currently


Post your requirement and let us connect you with best possible matches for Informatica Training Post your requirement now

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more