21/04/2012 Computer - Multimedia Classes

Price: Check with seller


Excellant informatica training in chennai adyar - Chennai@greens technology Free Demo Class avaiable Daily!! ======================PARTHIBAN========9840496320================== Learn INFORMATICA • Informatica 8.6 Why greens technology Real time Experienced Faculty with more than 5 years of experience working in MNC's like Infosys,IBM,Wipro.. Limited Batch size Online and corporate training available Real-time scenario project training Flexible timing Weekend batches available for working professionals. Guidance to Informatica Cetification 100 % job assistance Greens Technologys, No.15 First Street,Padmanabha nagar, Adyar, Chennai-20. Phone(M): +91 98404 96320 Phone(L): 044 43511623 eMail: Course contents Datawarehouse Concepts 1. Data Warehouse Introduction 2. Types of Datawarehouse 1)Enterprise Datawarehouse 2)Datamart 3)Operational Data Store 3. OLAP VS OLTP 4. Data Warehouse Architecture 5. Dimensional Modeling 6. Star Schema 7. Snowflake Schema 8. MultiStar Schema 9. Fact 10. Dimension 11. Slowly Changing Dimension 12. Confirmed Dimension 13. Junk Dimension 14. Change Data capture E T L Informatica Power Center 8.6.x & 9.0.x 1. Power Center Components a) Designer b) Repository Manager c) Workflow Manager d) Workflow Monitor e) PowerCenter Admin Console 2. Repository Administration a) Creating Repository Users and Groups . b) Connecting to the Repository. c) Creating a Group d) Assigning Privileges to a Group. e) Creating a User f) Creating a Folder g) Folder Permissions h) Creating Folders 3. Informatica Concepts and Overview a) Informatica Architecture. b) Informatica(Introduction) c) Source Analyzer d) Target Designer d) Transformation Developer e) Mapping Designer f) Mapplet Designer g) Task developer h) Worklet Designer i) Workflow Designer 4. Sources a) Working with relational Sources b) Working with Flat Files 5. Targets a) Working with Relational Targets b) Working with Flat file Targets 6. Transformations - Active and Passive Transformations a) Expression b) Lookup --Different types of lookup Caches c) Sequence Generator d) Filter e) Joiner f) Sorter g) Rank h) Router i) Aggregator j) Source Qualifer k) Update Strategy l) Normalizer m) Union Transformation n) SQL Transformation o) Debugging Mappings 7. Mappings & Mapplets a) Mapping Variables & Parameters b) Creating Mapping,Mapplet and reusable transformation c) Working with Mapping Wizards d) Slowly Changing Dimension 1) SCD Type1 2) SCD Type2 -- Date,Flag and Version 3) SCD Type3 8. Workflow Manger a) Creating Reusable tasks b) Workflows, Worklets & Sessions c) Tasks 1) Session 2) Assignment task 3) Control Task 4) Event raise task 5) Event wait task 6) Timer task d) Monitoring workflows and debugging errors e) Post session and Pre-session commands f) Session recovery g) Commit points 9. Performance Tuning a) Informatica Tuning (Source, target, mapping & Session) b) Informatica Pushdown optimization and pipeline partition c) Incremental aggregation 10. Differnet Kinds of Load a) Initial Load b) Incremental Load 11. Unix Commands and Basics of Unix Shell scripting 12. Project - Case Study 13. Resume Preparation and Assignment  

More Details

Total Views:16
Reference Id:#41659
Phone Number:994051384
Website URL:Click To Visit
Current Rating: /5 0 Vote
Copyright © 2018 |   All Rights Reserved | |   24x7 support |   Email us : info[at]