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
- 42349 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 studied btech in one of the university but i failed in some subjects so im editing all and trying to apply for ms in USA is there any problem..?? But i have all btech certificates of same college only..
Where can I get LAtest qtp 2010 exam questions ?
Dear Sir/Madam, I have passed lic ado written exam and my interview on 29th sep. I belong to OBC and I dont have current non creamy- layer certificate but I applied and will get within a month as per the new policies of State Govt, i have caste certificate and non creamy layer certificate of 2002. Can I eligible for the selection, plz reply me on anil_i13@yahoo.co.in or call me 09158153313.
I want to do a certification course on "corporate communication" let me know if anyone comeacross this
For WebSphere MQ clients on some platforms, if a security exit is not defined, the values of two environment variables MQ_USER_ID and MQ_PASSWORD are transmitted to the server. On which of the following platforms are these environment variables used?
hi i am a mbbs graduate appearing for all india post graduate exams,i belong to obc category and my dad is a doctor who is aged 70 and critically ill and not a earning member,my mom is a x-ray techinician and her monthly income is rs.6000,wil i come under creamy or non creamy category?
hi, i am MBA (Mkt & Fin) 2008. from UPTU Lucknow, i would like to know, which course (or certificate) can help me to get operational job. and any detail regarding SAP in finance. thanks in advance for reply.
How can we Change the IP-Phone/VM Login or Owner name in CME GUI Mode..
salary package for sap fico fresher (zero experinece)
I have complete the I.T.I electrician and 12 years experience on this field. How to get electrical supervisor certificate by tamilnadu electrical license board
List the Basic Steps for MM configuration.
I am an instrumentation engineer. Can anybody tell how to get certification from Saudi Aramco compnany?
When using the Nutanix Command Line Interface, which key is used to display a list of command options?
Please could any send me Informatica power center developer certification dumps @ tsailunet@gmail.com? Thanks in advance
Look at the figure. The first number of each host is the IP address, the second number is the subnet mask, and the last number is the default gateway. What is the problem with the TCP/IP network?
