Informatica
DCE Distributed Computing Environment
Dimensional Modeling Refresher
Data Staging Overview
Dimensional Data Staging
Introduction Informatica and Architectural Overview Informatica resources
Repository Topics
Source Object Definitions
Target Object Definitions
Transformation Concepts
Mappings
Workflows
Session Tasks
Workflow Monitoring
Debugger
Filter transformation
Aggregator transformation
Joiner transformation
Sorter transformation
Lookup transformation
Target options
Update Strategy transformation
Router transformation
Mapping Parameters and Variables
Conditional lookups
Heterogeneous Targets
Mapplets
Reusable transformations
Sequence Generator transformation
Dynamic Lookup
Concurrent and sequential
Workflows Additional Transformations
Advanced Server Features
Data Staging Overview
Dimensional Data Staging
Introduction Informatica and Architectural Overview Informatica resources
Repository Topics
Source Object Definitions
Target Object Definitions
Transformation Concepts
Mappings
Workflows
Session Tasks
Workflow Monitoring
Debugger
Filter transformation
Aggregator transformation
Joiner transformation
Sorter transformation
Lookup transformation
Target options
Update Strategy transformation
Router transformation
Mapping Parameters and Variables
Conditional lookups
Heterogeneous Targets
Mapplets
Reusable transformations
Sequence Generator transformation
Dynamic Lookup
Concurrent and sequential
Workflows Additional Transformations
Advanced Server Features
|
|
||||||||||
Training
Provided by Microsys Technologies and Solutions Pvt. Ltd.,
- asked: I would like to learn informatica in bangalore. Please let me know the details by sending mail to my mail id raj. com
- S asked: When is the training scheuled,the couse material,the version of informatica on which training will be provided,where is the training given. I mean i need the whole description about the training,like what is the duration,what will be the charge and what is the address of the place where the training will be delivered.
- S asked: Do you provide online course or any practice tests?
- S asked: I am interested in Informatica training in mumbai, is placement provided on completion of course and does it prepare you to get certified. Also can I get a reference from a previous student who has attended your training class. Please let me know. Thanks
- A asked: Hi Will appreciate if you can send me details about the course and the total fees. Also please let me know the percentage of practicals provided and do we get inforamtica software as a part of the training material. Thanks & Regards Alfa
- P asked: Do you teach Informatica programming (ver or higher) in the mid-atlantic United States (I live in the Washington, DC area). I'm a mainframe programmer (no prior Informatica exp.) so I'm looking for a comprehensive lecture/lab type course. Need info such as price and when available... Thanks
- R asked: How much is the cost. Is the course is in Bangalore Any job opportuinity after training. I am fresher(B.E. + MBA in IT).I have already done Business Intelligence course during MBA.I am elegible for this training.
- S asked: Hi, I am from gurgaon, and am working in S/w industry. I wanted to have information whether you are having institutes in Gurgaon for providing the Infomatica Certification training.
- M asked: Hi, I'd just like to inquire on the specific info regarding this training. The cost of the training and the place, if ever we choose to have an off-site training. Thanks!
- A asked: Hi I am interested to take a course on informatica. I currently work in a ETL project which uses PL/Sql . So I am looking for an intermediate course . I am planning the course for the month of december.Plse let me know u'r schedules ,course fee and other details . Thanks
- S asked: Could you tell something about the program
Informatica
DAY 1
Dimensional Modeling Refresher
Data Warehouse Architecture
Star and Snowflake Schema
Grain definition
Attributes, Dimensions and Facts
Slowly Changing Dimensions (Type1, 2, 3 and hybrid type)
Rapidly Changing Monster Dimensions
Role Playing Dimensions
Factless Fact Tables
Junk Dimensions
Sizing and Technology Selection/Architecture
Retail Case Study
Question Answer Session on Dimensional Modeling
Data Staging Overview
Importance of Good System Development Practices in Data Staging
High-Level Data Staging Plan
Data Staging tools
Detailed Plan
Dimensional Data Staging
Fact Table Loads and Warehouse operations
Data Quality and Cleansing
Aggregate Table and MOLAP Loads
Historical loads of Atomic-level Facts
Miscellaneous Issues
Introduction Informatica and Architectural Overview
Informatica resources
Informatica Professional Certification
Extraction, Transformation, and Loading process
PowerCenter 6 architecture
Additional Solutions
The Design Process
Repository Topics
Repository Server and Agent
Repository maintenance
Repository Server Administration Console
Security, repository privileges, and folder permissions
Object sharing, searching, and locking
Metadata extensions
Source Object Definitions
Source types
Source properties
Target Object Definitions
Target types
Target properties
Transformation Concepts
Transformation types and views
Transformation features and ports
Expression transformation
Informatica functions and data types
Mappings
Mapping components
Source Qualifier transformation
Pre SQL and Post SQL
Mapping validation
Data flow rules
Object export and import
DAY 2
Workflows
Workflow Tools
Workflow structure and configuration
Workflow Connections
Workflow Tasks
Workflow Design and properties
Session Tasks
Session Task properties
Session components
Transformation overrides
Session partitions
Workflow Monitoring
Workflow Monitor views
Monitoring a Server
Actions initiated from the Workflow Monitor
Filtering views
Truncating Monitor Logs
Debugger
Debugger features
Debugger windows & indicators
Tips for using the Debugger
Filter transformation
Filter properties
Aggregator transformation
Aggregation functions and expressions
Aggregator properties
Using sorted data
Incremental Aggregation
Joiner transformation
Joiner types
Joiner conditions and properties
Joiner usage and Nested joins
DAY 3
Sorter transformation
Sorter properties
Sorter limitations
Lookup transformation
Lookup principles
Lookup properties
Lookup techniques
Target options
Row type indicators
Row loading operations
Constraint-based loading
Rejected row handling options
Update Strategy transformation
Update Strategy expressions
Smart aggregation
Refresh strategies
Router transformation
Using a Router
Router groups
DAY 4
Mapping Parameters and Variables
Mapping parameter and variable usage
System Variables
Variable functions
Conditional lookups
Usage and techniques
Advantage
Functionality
Heterogeneous Targets
Heterogeneous target types
Target type conversions and limitations
Mapplets
Functionality and advantages
Mapplet types and structure
Mapplet limitations
Reusable transformations
Advantages
Limitations
Promoting and copying transformations
Sequence Generator transformation
Using a Sequence Generator
Sequence Generator properties
Dynamic Lookup
Dynamic lookup theory
Usage and functionality
Advantages
Concurrent and sequential Workflows
Concurrent Workflows
Sequential Workflows
Stopping, starting, and suspending tasks and workflows
Additional Transformations
Rank transformation
Normalizer transformation
Stored Procedure transformation
External Procedure transformation
Advanced External Procedure transformation
Transaction Control transformation
Advanced Server Features
Partitioned Extraction and Loading
Session DTM Parameters
Folder Management
Repository Reporting
Installation and Configuration
Dimensional Modeling Refresher
Data Warehouse Architecture
Star and Snowflake Schema
Grain definition
Attributes, Dimensions and Facts
Slowly Changing Dimensions (Type1, 2, 3 and hybrid type)
Rapidly Changing Monster Dimensions
Role Playing Dimensions
Factless Fact Tables
Junk Dimensions
Sizing and Technology Selection/Architecture
Retail Case Study
Question Answer Session on Dimensional Modeling
Data Staging Overview
Importance of Good System Development Practices in Data Staging
High-Level Data Staging Plan
Data Staging tools
Detailed Plan
Dimensional Data Staging
Fact Table Loads and Warehouse operations
Data Quality and Cleansing
Aggregate Table and MOLAP Loads
Historical loads of Atomic-level Facts
Miscellaneous Issues
Introduction Informatica and Architectural Overview
Informatica resources
Informatica Professional Certification
Extraction, Transformation, and Loading process
PowerCenter 6 architecture
Additional Solutions
The Design Process
Repository Topics
Repository Server and Agent
Repository maintenance
Repository Server Administration Console
Security, repository privileges, and folder permissions
Object sharing, searching, and locking
Metadata extensions
Source Object Definitions
Source types
Source properties
Target Object Definitions
Target types
Target properties
Transformation Concepts
Transformation types and views
Transformation features and ports
Expression transformation
Informatica functions and data types
Mappings
Mapping components
Source Qualifier transformation
Pre SQL and Post SQL
Mapping validation
Data flow rules
Object export and import
DAY 2
Workflows
Workflow Tools
Workflow structure and configuration
Workflow Connections
Workflow Tasks
Workflow Design and properties
Session Tasks
Session Task properties
Session components
Transformation overrides
Session partitions
Workflow Monitoring
Workflow Monitor views
Monitoring a Server
Actions initiated from the Workflow Monitor
Filtering views
Truncating Monitor Logs
Debugger
Debugger features
Debugger windows & indicators
Tips for using the Debugger
Filter transformation
Filter properties
Aggregator transformation
Aggregation functions and expressions
Aggregator properties
Using sorted data
Incremental Aggregation
Joiner transformation
Joiner types
Joiner conditions and properties
Joiner usage and Nested joins
DAY 3
Sorter transformation
Sorter properties
Sorter limitations
Lookup transformation
Lookup principles
Lookup properties
Lookup techniques
Target options
Row type indicators
Row loading operations
Constraint-based loading
Rejected row handling options
Update Strategy transformation
Update Strategy expressions
Smart aggregation
Refresh strategies
Router transformation
Using a Router
Router groups
DAY 4
Mapping Parameters and Variables
Mapping parameter and variable usage
System Variables
Variable functions
Conditional lookups
Usage and techniques
Advantage
Functionality
Heterogeneous Targets
Heterogeneous target types
Target type conversions and limitations
Mapplets
Functionality and advantages
Mapplet types and structure
Mapplet limitations
Reusable transformations
Advantages
Limitations
Promoting and copying transformations
Sequence Generator transformation
Using a Sequence Generator
Sequence Generator properties
Dynamic Lookup
Dynamic lookup theory
Usage and functionality
Advantages
Concurrent and sequential Workflows
Concurrent Workflows
Sequential Workflows
Stopping, starting, and suspending tasks and workflows
Additional Transformations
Rank transformation
Normalizer transformation
Stored Procedure transformation
External Procedure transformation
Advanced External Procedure transformation
Transaction Control transformation
Advanced Server Features
Partitioned Extraction and Loading
Session DTM Parameters
Folder Management
Repository Reporting
Installation and Configuration
About The Training Provider: Microsys Technologies and Solutions Pvt. Ltd.,
Microsys Technologies and Solutions Pvt. Ltd., - Microsys Technologies & Solutions Pvt. Ltd is a proactive organization headquartered in Pune with its branches across Mumbai & Bangalore. In the last few years of our existence we have successfully offered value propositions to our clientele across the country and overseas.
Customized Software Development
Corporate Training & IT Education
leadership and management skill programs
...
