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
- 43669 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
what are the factors effecting the curriculam
Hi I am E&C B,E graduate..From past 3 yers working in ICICI Bank non technology gruop..what certification helps me to get advatage of both Technical and banking knowledge?
Can anybody please tell me , how do we integrate HR & FI in SAP. Thanks & Regards, Neha
ihave lost my documents before the sbi interview
PMP certification. Please call 9866654045
Sir, I am diploma in electronic engineering student and having five years experience in electrical maintenance including three years in switchgear electrical.... Can I am eligible for electrical supervisor certificate.... Please write me..
can anybody help me providing sample paper to clear red hat certification..
why join as medical representative
I am an diploma holder in electronics & communication engineering. Am I eligible to get c license.Pl let me about it.
hi ,i am going to give advance sas exm but i dnt have dumps so if any one have recently advance paper and answer please mail me- diffmail172@gmail.com tHank you
hi i done IBM AS/400 course .....i want to certification any one can information about that and material of soft copy for that....please its urgent
i want study matterials and syllabus for hpux 11i v3 based certification (hp0-a01) for HPUX system administration.
I am planning to take informatica 9.x certification.Looking for Informatica 9.x certification dump.
Hi I want to do certification on security trading.Any idea ?
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.
