Data Warehousing/Informatica Classes In Pune

Hi All,

We are industry experts providing training for DATA WAREHOUSING, Informatica ,Unix ,Oracle(SQL/PL-SQL) with project.
Faculty: Real-time, Experienced.
Duration: 2 Months (64 hours) - Weekends
Location: Vishrantwadi,Pune
Eligibility: Any Enginneering graduate or experience professional can learn
Contact details: Girish, 164,C-Wing,Shoppers Orbit,Vishrantwadi,Pune-15
Contact No: 9011025200
Main Feature: Till Time 95% students got job in big MNC’s.
Timing: 9 am -1 pm. Batches will be on week-ends only.
We will cover following topics::
 Oracle-SQL/PL-SQL
 Data warehouse Concepts
 Unix Basics
 Informatica----all concepts and scenarios will be covered practically.
 Informatica project
 Optional: ETL testing training
Syllabus:
1st week: SQL –all SQL queries including practical scenarios with interview questions on SQL.
2nd week: Data warehousing concepts- with practical design approach.
Installation of all software’s, Overview of Informatica architecture, server, client, domain and nodes with Sample Informatica mapping
3rd week: Work Flow Manager, Monitor , Session, Repository, Integration service, Folder, Source Analyzer, Target Designer, Mapping, Mapplet, transformation developer, Active and Passive Transformations, Expression, Filter, router, sorter, sequence generator.
4th week: Aggregator, Joiner, Rank, Lookup(Static,dynamic,persistent,non-persistent,connected,un
connected), Stored procedure, java, normalizer, Transaction control
5th week: SQL transformation, Update strategy, Workflow task: Session, command, email, event wait, event raise, timer, link, decision, control, assignment ,worklet
6th week: SCD 1, SCD2, SCD3,CDC,Parameterization(mapping, session and workflow level),pmcmd command, Pushdown optimization, performance optimization, checksum number approach,MD5 implementation,, Live scenarios.
7th week: Project
8th week: Project, Basic UNIX, Interview Prep, Q&A, Resume preparation and mock interview practice
>> for details information please call will send detail syllabus on your mail.

Key Points::
• Real time scenarios
Practical Implementation of SCD1, SCD2, SCD3
Implementation of CDC
Other useful scenarios will be covered.
• Exercises for each Transformation and will teach installation
• Real-time Overview of Informatica code Delivery and deployment process.
• Real time Questions and Answers.
• Data ware housing Concepts.
• Testing Approach (Unit Testing, Integration Testing).
• Project will be covered (Which will give full real-time experience about end to end Informatica Project Implementation) .
• All study material will be provided which includes step by step implementation.
• Informatica Installation step by step implementation:

Batch Starting: New Batch starting from 31 May 2014 (9 am -1 pm).batches will be on week-ends only