| Course Others | You are Offering Professional Course | Locality Vishrantivadi |
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, 127,A-Wing,Shoppers Orbit,Vishrantwadi,Pune-15
Contact No: 9011025200
Main Feature: Till Time 95% students got job in big MNC’s.
New Batch Starting: New Batch starting from 21 September 2013 (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 21 Sept 2013 (9 am -1 pm).batches will be on week-ends only