Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Share

course photo

Best informatica Training+100% Placement assistance Institute in Bangalore - Bangalore

Koramangala, Bangalore

No Feedback Yet

No Reviews Yet
8 Interested

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

INFORMTICA SYLLABUS
CHAPTER 1: TOOL KNOWLEDGE
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
1.2.6 INTEGRATION SERVICE
1.2.7 WEB SERVICES HUB
1.2.8 DATA ANALYZER
1.2.9 METADATA MANAGER
CHAPTER 2: REPOSITORY MANAGER
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
CHAPTER 3: DESIGNER
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
CHAPTER 4: WORKFLOW MANAGER
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

SQL SYLLABUS:

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
DWH SYLLABUS:

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.
BASIC UNIX COMMANDS:







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.

Pre-requisites

(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
Content
Reviews
There are no Reviews yet.
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions


There are no Reviews yet.
cash back100% Money Back Guarentee

About the Trainer

bavish picture

bavish

mtech


7-8 years in industry exeperience

Course Id: 16603