Informatica Course Content:
Introduction to Data warehousing:
- Introduction and Architecture
- Architecture and Software Overview
- ETL and ELT Architecture Overview
- Partitioning and Parallelism Introduction
- Power Center Services RAM Utilization
- Differences Between 32 bit and 64 bit
- Client Software Overview
- Introduction to Designer Interface
- Introduction to Workflow Manager Interface
- Introduction to Workflow Monitor
- Introduction to Repository Manager
- Software Demonstration
- Source Object Definitions
- Flat File Sources
- Relational Sources
- Data Previewer
- Metadata Extensions
Assignment:
- Import a Source
- Target Object Definitions
- Target Definitions
- Target Properties
- Flat File Targets
- Relational Targets
Assignment:
- Import a Target
- Mappings
- Defining a Data Flow Diagram
- Transformation Objects and Views
- Source Definition and Source Qualifier
- Pre-SQL and Post-SQL Rules
- Expression Transformation
- Informatica Functions
- Variable Ports
- Data Types
- Mapping Validation
Assignment:
- Create a Working Mapping
- Workflows
- Workflow Tools
- Workflow Structure
- Workflow Connections
- Workflow Tasks
- Workflow Design Process
- Workflow Properties
- Workflow Links
- Session Tasks
Assignment:
- Configure a Workflow and Session
- Monitoring Workflows
- Workflow Monitor Views
- Monitoring a Server
- Actions Initiated from the Workflow Monitor
- Filtering Views
- Truncating Monitor Logs
- Stop Versus Abort
Assignment:
- Run and Monitor the Workflow
- Demonstration of Designer Features
- Debugger
- Debugger Features
- Debugger Windows and Indicators
- Debugger Best Practices
Assignment:
- Debug the Mapping
- Filter Transformation
- Filter Functionality
- Filter Properties
- Filter Versus DB Where Clause
Assignment:
- Create a Filter Transformation, Run Workflow
- Sorter Transformation
- Sorter Functionality
- Sorter Properties
- Sorter Versus Database Order by Clause
- Aggregator Transformation
- Aggregator Expressions and Functions
- Using Unsorted and Sorted Data
- Data Flow Rules
- Aggregator Versus Database Group By
- Joiner Transformation
- Homogeneous and Heterogeneous Joins
- Joiner Conditions and Properties
- Joiner Usage
- Nested Joins
- Joiner Versus Database Join
Assignment:
- Add Sorter, Joiner, and Aggregator
- Lookup Transformation
- Lookup Principles
- Lookup Properties
- Lookup Caching
- Lookup Versus Database Join
Assignment:
- Create a Basic Lookup
- Target Options
- Target Properties
- WHERE Clause
- Constraint-Based Loading
- Target SQL Override Best Practices
- Update Strategy Transformation
- Update Strategy Transformation
- Update Strategy Expressions
- Update Strategy Best Practices
Assignment:
- Create a Type 2 Dimension Update
- Router Transformation
- Router Functionality
- Router Groups
Assignment:
- Use a Router to Delete Rows
- Data Driven Versus Session Switches
- Parameters and Variables
- Parameter Scoping
- System Variables
- Mapping Parameters and Variables
- Variable Functions
- Unconnected Lookups
- Usage and Techniques
- Advantages
- Functionality
- Conditional Lookups
Assignment:
- Create an Unconnected Lookup
- Heterogeneous Targets
- Heterogeneous Target Types
- Target Type Limitations and Conversions
Assignment:
- Build Heterogeneous Targets
- Mapplets
- Mapplet Designer
- Mapplet Advantages
- Mapplet Types and Rules
- Active and Passive Mapplets
- Mapplet Parameters and Variables
- Mapplet Designer Best Practices
Assignment:
- Build a Mapplet
- Reusable Transformations
- Transformation Developer
- Rules
- Promoting and Copying Transformations
- Transformation Developer Best Practices
Assignment:
- Create and Use a Reusable Transformation
- Sequence Generator Transformation
- Sequence Generator Functionality
- Sequence Generator Properties
- Sequence Generator Best Practices
Assignment:
- Create a Variable Based Sequence Generator
- Error Logging
- Setting On and Off
- Data Rejects with Error Logging Off
- Error Logging to Database Table and Flat File
- Source Row Logging
- Error Logging Best Practice Architecture
- Workflow Configuration
- Server Connections
- Reusable Workflow Schedules
- Reusable Session Configurations
Assignment:
- Create a Sequential Workflow
- Create a Concurrent Workflow
- Reusable Tasks
- The Command Task
- The Email Task
- Reusable Task Best Practices
- Non-Reusable Tasks
- The Decision Task
- The Assignment Task
- The Timer Task
- The Control Task
- The Event Wait Task
- The Event Raise Task
- Non-Reusable Tasks Best Practices
Assignment:
- Create Event Wait/Event Raise and Timer
- Create a Control and Assignment Task
- Create a Command Line Task
- Worklets
- Reusable Worklet
- Non-Reusable Worklet
- Worklet Best Practices
REACH US AT
+91-9553406450
+91-9666993220
+91-4040061338
+1 (610) 340-4192
info@akirait.com