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
- 43154 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
Identify the class of IP addresses that will be used for an organization having a network of between 1000 to1500 computers. Explain your reasons for arriving at this solution. Design a sub netting system for the same organization described in upper . Each sub net should contain no more than 100 computers. Show the overall network using a diagram. Support your proposal with sound technical arguments.
what is the thing that is created adjacent to the transparent table created on the database? a)fields b)data element c)structure 4)table type ques2)what operation you cannot perform on internal table? a)append b)sort c)insert d)modify e)delete
please give us the detail about the company HESS CORPORATION , 1-11 Jhon street London
what kind of certification should i go for and from where for doing erp- sap in sd module.
is there use of doing CEIS certification by karRox for other industry rather than IBM? if yes name the company's who approve for such certifications?
hi, 2012 I got an invitation for a organization conference and I was deny in 2013, I also got an invitation form my friend who is American citizen to visit her just two weeks and I was also deny. can I still apply for a visa if the possibility is there?
what is meant 'histry of arears'? and how to calculate it?
Where can I get LAtest qtp 2010 exam questions ?
Does anyone of test questions for the NCCER Instrument Technician V3 test?
In sap sd what is the difference the cerification vode C_TSCM62_60 , C_TSCM62_62 and C_TSCM62_64 . Which one one should take if a fresher is taking which will add more value to resume.
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.
ihave lost my documents before the sbi interview
Can anyone give me Teradata TA0-121 certification exam dumps.....If anyone has plz send me on my mail Id bpshekhawat@gmail.com Thanx in advance.................
what is an added benefit for using vortex pumps?
Please could any send me Informatica power center developer certification dumps @ tsailunet@gmail.com? Thanks in advance
