This test has been designed to evaluate the fundamental understanding and familiarity of the test taker with Informatica at different levels. The assessment covers the fundamentals of Informatica as well as more advanced concepts for Informatica Developers. Subjects include Informatica Tools and Concepts, Mapping and Mapplets, Transformations and their usage, Load Manager, Update Strategy, and performance tuning concepts. The author used Informatica 8.2 when writing this assessment. Assessments for Data Warehousing Concepts and OLAP Concepts are also available. Total Questions 40 Question Types Multiple Choice Competencies Tested Tools, Components, and ConceptsMappingTransformationPerformance Tuning Tasks Tested Concurrent BatchDesignerBreakpoints in DebuggerDebugger Process & StrategyDD_DELETE ValueWorkflow TasksCode PageInformatica Client ToolTypes of LocksCommand LineSupported File TypesMapping ParameterTransformationsAdding a SourceMapping ComponentsTarget DefinitionUpdate StrategyFilter Transformation UsageFilter PortsExpression TransformationStored ProcedureAggregator Transformation DefinitionJoinerSource Qualifier TransformationSource RecordAggregator Transformation ComponentMultiple Rows Out of Single RowTransformation TypeLookup Transformation TypeRouter Transformation DefinitionTop/Bottom Values in SeriesFilter Transformation UseRank TransformationData Transformation ManagerOptimizationLookup Cache TypeLoad ManagerPartitioningCommit Points
