Core Data Corp

I am an IT consultant with 9 years of work experience. I am providing professional training in Informatica Powercenter and will use version 9.5.1 (Latest) I will also provide my own created handbook for reference along with software. I will install software on your laptop and teach you configuration for practice at home. I will also provide real time project & hand on experience details for real knowledge of how things happen. Informatica is the best ETL in market and provides a very good career advantage. People who are willing to study and make a career without worries of complex programming can join the course and move on a path of happiness & good salary. Informatica is a RDBMS management tool which provides data integration services that enable organizations to analyse relevant trustworthy data timely. This is a Job Oriented course designed for people looking for Job in Database Integration and RDBMS Management. Duration of this course is working days :- Introduction to Data warehousing 1. Overview of a DWH 2. Need of a data warehouse. 3. Data warehouse layer architecture. 4. OLTP/Transactional system and OLAP 5. Meta Data, Granularity, Data Mart 6. Design approach Top down/Bottom up 7. Designing a warehouse using Star/Snowflake schemas. 8. Dimension 9. Fact . CDC approach Introduction to Informatica/ETL tools 1. The role of ETL tools in data warehousing. 2. An introduction to Informatica 3. Informatica Architecture 4. Components/Process flow Informatica Designer 1. Basic Concepts 2. Using the designer. 3. Working with the Sources-Source Analyzer 4. Working with Relational/Flat file targets- Warehouse Designer. 5. Defining Keys in Informatica. 6. Working with Transformations - Transformation Developer 7. Working with Mapplets- Mapplet designer. 8. Creating mappings - Mapping Designer. 9. Understanding Pipelines in mappings. . Setting Target Load order. . Configuring Constraint Based loading. . Introduction to Mapping Parameters/Variables. . Implementing Type1, Type2, and Type3 Mappings. Working with Transformations 1. Active/Passive Transformations 2. Connected/Unconnected Transformation 3. Importance of Source Qualifier. 4. Filter, Router 5. Expression 6. Sorter, Aggregator 7. Rank 8. Joiner 9. Lookup . SQL . Stored Procedure . Sequence generator . Union . Update Strategy . Xml transformation Creating Workflows 1. Understanding the server Architecture 2. Working with Workflows 3. Working with Tasks Assignment,Command,Decision,Control,Event raise, 4. Event Wait,Timer,Email,Session Task 5. Working with Work lets 6. Working with Sessions 7. Understanding Commit Points 8. Recovering Data 9. Monitoring Work flows . Using Multiple Servers . Log files . Row Error Logging . Session parameters . Parameter files . Using Incremental Aggregation Basic oracle and unix only for interview point of view Mini project Interview question and scenario