Overview

Faculty: Informatica Certified consultant Data Warehousing Concepts Data WarehouseData MartOLAP VS OLTPData Warehouse Architecture (Basic)Data Warehouse Architecture (with a Staging Area)Dimensional ModelingStar SchemaSnowflake SchemaDimensionFactSlowly Changing Dimension(Type 1,2 and3)HierarchyConfirmed DimensionFact less Fact Table.Summary / Aggregations tableChange Data capture Power Center Components DesignerRepository ManagerWorkflow ManagerWorkflow Monitor Informatica Concepts and Overview Informatica Architecture.Source QualifierTarget DesignerTransformationsMappingsMappletsSessionsTasks Sources Working with relational SourcesWorking with Flat Files Targets Working with Relational TargetsWorking with Flat file Targets Transformations Expression TransformationLookup TransformationSequence Generator TransformationFilter TransformationJoiner TransformationSorter TransformationProcedural TransformationRouter TransformationAggregator TransformationUpdate Strategy TransformationUnion TransformationRank TransformationTransaction Control TransformationNormalizer TransformationSource Qualifier TransformationStored Procedure TransformationXML Source Qualifier TransformationDebugging Mappings Power Center Transformation Language Numeric functionsString FunctionsDate FunctionsConversion FunctionsCleansing FunctionsAggregate FunctionsUser Defined Functions ADVANCED INFORMATICA CONCEPTS Unconnected lookup TransformationUnconnected Stored Procedure to Create and Drop IndexMapplet and Types of MappletsDefining Reusable Transformations.User Defined FunctionsTasks And Types of TasksWorklet and Types of WorkletsScheduling Work flowConstraint Based Load OrderingTarget Load PlanTypes of Batch ProcessingLink conditionsMapping ParametersMapping VariablesDefining Session ParametersSession RecoveryDifference Between Normal and Bulk LoadingPush Down OptimizationPMCMD UtilityPMREP UtilityIncremental Aggregation TYPES Of LookUp Caches Static LookUp CacheDynamic LookUp CachePersistence lookup CacheShared LookUp CacheSorter and Rank Cache Task Types SessionCommandEMAILTimerEvent WaitEvent RaiseDecisionAssignmentControlWorklet ETL Testing UNIT TestingSystem Integration testingPERFORMANCE TESTINGETL Performance Optimization techniques

Skills

Reviews