Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
I want to join in best training center for
Informatica course in Chennai. Who really teaches well
So please let me know.
Thanks,
Raji
- 22 Answers
- 42897 Views
- I also Faced
- E-Mail Answers
Answer Posted / sarasteq
Call Us @ +91 7795671819
Email ID: training.sarasteq@gmail.com
SARASTEQ -Best Informatica 9.5 training Institute in Marathahalli, Best Informatica training Institute in Bangalore
Datawarehousing can be broadly classified into two verticals:- ETL and Reporting. Informatica is one of the leading ETL tool in the Datawarehousing space. Using Informatica we can extract transform and load data into Datawarehouse, Datamart an ODS. There are multiple products from informatica cooperation like Informatica powercenter, IDQ, Power Exchange, Informatica Vibe etc. We will be mainly focusing on Informatica powercenter tool.
It is the pride of SarasTeq Technical training Institute that we have a faculty with 18+ years of experience in database and datawarehousing to train you everything about Datawarehousing and Informatica in Bangalore. He has implemented more than 15 datawarehouses across multiple clients and has trained over 800 resources in datawarehousing. He is currently working as a delivery manager with one of the top MNCs.
Register for our free Informatica demo class on Mondays, Tuesdays, and Thursdays at 8:30 am & on Saturdays at 10:30 am before you make the choice...!
Course Details
Basic SQL
Basic Of Unix
Data warehouse basics
OLTP System
Datawarehouse
Different Definitions of datawarehouse
Data Marts
Types of Data Marts
Top-down and Bottom up approach
Difference between OPERATIONAL DS AND DWH
Types of ETL tools
Data scrubbing
Data cleansing
Data Extraction
DataTransformation
Data Merging
Data Loading
Types of Data loading
Data Aggregation
Datawarehouse Approaches
Top down approach and Bottom up approach
DWBI Life cycle
DW-database design
ETL life cycle phases
Star schema and Snow flake schema
Dimensional modelling
Facts and dimensions
Granuality
Types of Dimensions
Types of fact table
Types of OLAP
Informatica Power Center 9.1
Power center Administration
Informatica Power center architecture
Basic Objects of Informatica Power Center
Power center components
Power center Clients
Desiginer Options
Workflow manager Options
Work Flow monitor Options
Repository manager Options
Power center repository
Repository services
Integration services
Power center domain
Concept of nodes and grid
Power center administration console
PowerCenter Designer Objects
Creating Source Tables.
Creating Target Definitions.
Creating Target Tables
Creating a Pass-Through Mapping
Creating source definitions
Creating a Mapping
Creating Session
Creating Workflow
Creating ODBC connections
Creating Relational Connections
Creating a Mapping with Aggregate Values
Active and passive transformations
Connected and unconntectd transformations
Transformations which create Cache
Aggregator Transformation
Expression Transformation
Filter
Router
Rank
Sorter
Stored Procedure
Sequence Generator
Joiner
Union
TCT
UPD
Normalizer
Source Qualifier
XML source Qualifier
SQL Transformation
OVER view of JAVA transformation
Lookup Transformation
Creating a Mapping with SCD Type 1 and SCD Type 2
How to monitor loads
Use of Workflow monitor
Using the workflow manager
Connecting Transformations
Creating Sessions and Workflows
Configuring Database Connections in the Workflow Manager
Creating a Reusable Session
Creating a Workflow
Running and Monitoring Workflows
Opening the Workflow Monitor
Incremental aggregation
Workflow Tasks
Session
Assignment task
Link task
Event raise task
Event wait task
Timer task
Control Task
Assignment Task
Decision Task
Email task
Command Task
Schedular
Post session and Pre-session commands
Session recovery
Commit points
Creation of Parameter file
Mapping and session parameter
Performance tuning in ETL
Various optimization technique
Pushdown optimization
Repository Administration
Creating Repository Users and Groups .
Connecting to the Repository.
Creating a Group
Assigning Privileges to a Group.
Creating a User
Creating a Folder
Folder Permissions
Creating Folders
Project
Interview Tips
Pre-Requisite
Graduate/Fresher/Software Developer/Working Professional with Basic SQL
We Provide
•Classroom Training
•Corporate Training
•Online Training
Duration
45-50 hrs Real Time Training Classes on Informatica.
Timings & Schedule
Both on Weekdays / Weekends
Lab
Along with theory classes, we provide hands on exposure to students on Informatica in our lab. Our lab is open from morning 7:30 till evening.
Course Material
We provide latest FREE Informatica course materials to you, so you don’t have to strain too much on taking notes.
Mock Exams
Our team will conduct Mock Exams to test your learning level and will provide extra classes to sharpen your weak areas.
Mock Interviews
Mock interviews will be conducted by Informatica trainer
Career Guidance
We will guide through what career to take up, which company to apply, how to apply for a job, what more to learn, what to do and what not to do in an interview and so on, if you consider Informatica training in Bangalore @ Sarasteq.
Resume Tips
A resume should be catchy. We will help you chisel your resume into a brand new eye-catching one, if you consider Informatica training in Bangalore @ Sarasteq.
Who should consider this training?
Informatica training in Bangalore will be helpful in building careers for people working for a big brand from the past 3-5 years into some legacy technologies like IBM mainframes, production Support, SQL/PLSQL developer college pass-outs, software testing professionals.
Call Us @ +91 7795671819
Email ID: training.sarasteq@gmail.com
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
I want take up LoadRunner Testing Certification. Can anyone help me with the Syllabus and some sample questions. Also please tell me how much it costs for the Basic level testing.
I am complietd DECE passing year 2006. But i am working ht line electrical field in Private textile company. How i can get electrical C liecense. Please clearify my doubt my no.9047566688
Can anybody help me to provide sample paper to clear Red Hat Certification?
ihave lost my documents before the sbi interview
Can any one please suggest me about certification in Mainframe.I have two year experience in Mainframe though i want to purse standard mainframe certification like Oracle certification...
how we can protect the chroot /mnt/sysimage with password
Do you know at least 5 principles of a database system? plz send me with examples
dosto bank ki interview me challan jaroori hota h ka sbi ka interview h plz btao me
I want to do QTP Mercury Certification, give me an idea and the where can i register for that?
I am an diploma holder in electronics & communication engineering. Am I eligible to get c license.Pl let me about it.
Can anyone pass on the certification dump for informatica 8.x to prshri@gmail.com ? I appreciate your help
can anybody help me providing sample paper to clear red hat certification..
Hi anybody have Juniper switching certification (JNCIA-EX) dumps coz i have an exam on this 30 july but i have nothing to read about the exam. if have then kindly email me (mr.asadji@hotmail.com) I will be remain thankful.
Can anyone of u pls suggest some good bit easy certification for QTP if any material found pls mail to pvlavanya@rediffmail.com
How can we Change the IP-Phone/VM Login or Owner name in CME GUI Mode..
