INFORMATICA Online Training Course @ BigClasses INFORMATICA Online Training course from BigClasses.com 1)In-depth job oriented training by Real Time Experts 2)100% PLACEMENT Assistance 3) Special offers for OPTs & CPTs 4) Refer & Get $ 50 OFF to U & Ur Friend 5) Support after Training course Full ad description: INFORMATICA Online Training classes at BigClasses.com Join FREE DEMO to Experience the Quality of our Training
Training Highlights: * Job Oriented Training by Industry Experts * Training at Learner's Convenience (Regular & Weekend) * Customized Curriculum * Two Free Trial Classes * Support after Training a) Resume Preparation b) Certification Guidance c) Interview preparation * 100% Satisfaction Guaranteed!!! We Offer: * 100% Placement assistance * ON-JOB Support http://www.bigclasses.com/informatica-online-training.html * BIG REFERRAL benefits * Remote Software Installation * Special offers for OPTs & CPTs
ABOUT BIGCLASSES.COM BigClasses.com is a Global Online Learning Portal started by proven industry experts with an aim to provide Quality Training on all the IT Technologies. BigClasses.com team has pool of Expert Trainers from worldwide on all the technologies to train the students. About Our faculty we have excellent instructors who have real time 5+ years of experience plus good experience in Online Training We have an upcoming online batch on INFORMATICA Other Data warehousing Tools offered: Reporting Tools : Business Objects, OBIEE, MicroStrategy ETL Tools : Informatica, DataStage, Abinitio, BO DI. Other Tools : SAP BW BI, MS BI, TeraData, SAS. We also provide Online Training on: Data Warehousing All Tools SAP http://www.bigclasses.com/informaticaMicroSoft online-training.html JAVA Testing Tools
INFORMATICA Duration: 30 Hours DATAWAREHOUSING CONCEPTS: INTRODUCTION TO DATAWAREHOUSING •What is Data warehouse? •Components of Data warehouse •Decision support systems •OLTP Systems •OLTP vs DATAWAREHOUSE •ODS(Operational Data Store) •Difference between ODS and DATAWAREHOUSE •Data Mart •Difference between Data warehouse and Data Mart •Difference between Data warehouse and ODS,OLTP •Data warehousing for OLTP systems •Data cleansing •Independent Data warehouse •Dependent Data warehouse •Meta data and Data Mining •OLAP,ROLAP,MOLA ●
INFORMATICA 8.6 Introduction of Informatica power center ETL Architecture Data source Data targets Repository Meta data Server components Client components INFORMATICA INSTALLTION SYSTEM REQUIREMENT CREATING DOMAIN CREATING NODE CONFIGURING DOMAIN WITH WEBSERVER ASSIGNING INFORMATICA SERVICES WITH ACCOUNTPOPULATING THE SALES ORG INFORMATICA POWERCENTER WEBADMINISTRATOR CONSOLE Creating Informatica Repository Services Creating integrated services INFORMATICA REPOSITORY MANAGER Creating the workspace(folder) Creating the users Changing the user passwords Creating users groups Giving privileges to the users, user groups and folder
INFORMATICA DESIGNER Connecting to the designer Components of the designer Creating DSN(data source name) Source, Database Accessing the source, definitions to the designer Warehouse Designer Creating the target Tables using warehouse designer Generating target Table to database Mapping Designer Mapping between the source and target Tables Transformations between source and target Tables
TYPES OF TRANSFORMATIONS:
Source qualifier Aggregator Filter Expression Stored Procedure Informatica Demo http://www.youtube.com/watch?v=uOo7LUySkt8 Lookup Informatica Demo http://www.youtube.com/watch?v=dOwMZyLf9Ao Sorter Joiner Informatica Demo http://www.youtube.com/watch?v=1j1eXt2aJEE Router Xml source qualifier Update strategy Normalizer Ranking Sequencer Generator http://www.bigclasses.com/informaticaTransaction control online-training.html Union Custom Cubes and Dimensions(creating star schema) Slowly Changing Dimensions(SCD) Mapplets Reusable transformations Debugger Working with mapping using Debugger Data Profiling Variable and Parameters New Features in power centre 7.1
WORKFLOW MANAGER
Components of workflow manager Types of tasks Session E-mail Command Creating workflow Scheduling the workflow Creating connections Assigning connection values to the sessions Assigning server to workflow Workflow monitor Session logs Workflow logs http://www.bigclasses.com/informatica-online-training.html