INFOREMATICA ONLINE THE BEST AT HYDERABAD TRAININGS IN INDIA

Informatica classroom/online with job oriented best coaching in Sandsys with live projects by Real-Time experts and low fees. Course NameInformatica Demo ClassesMorning & Evening In Week Days VenueSandsys Technologies TrainerHaving 7+ years of experience MODE OF TRAINING: NORMAL TRACK FAST TRACK ONLINE DURAION: 30 DAYS 15 DAYS 30 Days DAILY SESSION: 1hr 30min 2hr 30min 1hr 30min LAB SESSION: 7AM – 9PM SOFTCOPY OF MATERIAL AND SOFTWARES REAL-TIME PROJECT WITH EXPLANATION 100% JOB ASSURANCE CONTENT DATAWAREHOUSING CONCEPTS: •Introduction to Datawarehousing •Data Modelling(Schemas, FACTS and DIMENSIONS) •Slowly Changing Dimensions •Metadata INFORMATICA POWERCENTER 8.6 COURSE CONTENTS •INFORMATICA OVERVIEW oHistory of Informatica oOpportunities of Informatica oOther ETL tools oPower center Administration oInformatica Power center architecture oPower center components oETL Plan oPower center Clients oDesigner oWorkflow manager oWork Flow monitor oWorkflow manager oRepository manager oPower center repository oAdministrative tool oRepository services oIntegration services oPower center domain oApplication services oConcept of nodes and grid oService manager oPower center administration console oRepository Administration oCreating Repository Users and Groups. oConnecting to the Repository. oCreating a Group oAssigning Privileges to a Group. oCreating a User oCreating a Folder oFolder Permissions •DESIGNER oTypes of Transformations oConnected and Unconnected Transformations oActive and Passive Transformations oCreating Source Tables oCreating Target Definitions oCreating Target Tables oCreating source definitions oCreating a Mapping oConnecting Transformations oTransformation Creation oImporting sources and targets (database objects) oImporting sources and targets (flat files and XML files) oUsing Transformations oAggregator Transformation oExpression Transformation oLookup Transformation (Connected and Un Connected) oUnion Transformation oJoiner Transformation oFilter Transformation oSequence Generator Transformation oStored Procedure Transformation oSource Qualifier Transformation oRouter Transformations oRank Transformations oUpdate Strategy Transformation oXML Transformation oSQL Override in source qualifier Transformation and lookup Transformation oConnecting the Target oConnecting Transformations oCreating a Mapping oCompleting the Mapping oCreating a Pass-Through Mapping oCreating a Mapping with SCD Type 1 and SCD Type 2 oCreating a Mapping with Aggregate Values oTarget load order plan oMapping wizards oReusable Transformation oMapplet overview and usage •WORKFLOW MANAGER oCreating the Session oCreating the Workflow oUsing the workflow manager oCreating Sessions and Workflows oConstraint base loading oConfiguring Database Connections in the Workflow Manager oCreating a Reusable Session oCreating a Workflow oRunning and Monitoring Workflows oOpening the Workflow Monitor oWorkflow Tasks oSession oAssignment task oLink task oEvent raise task oEvent wait task oTimer task oPost session and Pre-session commands oSession recovery oCommit points oCreation of Parameter file oMapping and session parameter oPerformance tuning in ETL oVarious optimization techniques oPushdown optimization oIncremental aggregation •WORKFLOW MONITOR oHow to monitor loads oUses of Workflow monitor oMonitoring the jobs oHow to get Session Logs and Workflow Logs •Real time Questions and Answers •Real time scenarios