Datawarehousing Informatica Online Training
Details
- INFORMATICA OVERVIEW
- History of Informatica
- Opportunities of Informatica
- Other ETL tools
- Power centre Administration
- Informatica Power centre architecture
- Power centre components
- ETL Plan
- Power centre Clients
- Designer
- Workflow manager
- Work Flow monitor
- Workflow manager
- Repository manager
- Power center repository
- Administrative tool
- Repository services
- Integration services
- Power center domain
- Application services
- Concept of nodes and grid
- Service manager
- Power center administration console
- Repository Administration
- Creating Repository Users and Groups
- Connecting to the Repository
- Creating a Group
- Assigning Privileges to a Group
- Creating a User
- Creating a Folder
- Folder Permissions
- Creating shortcuts
- DESIGNER
- Types of Transformations
- Connected and Unconnected Transformations
- Active and Passive Transformations
- Creating Source Tables
- Creating Target Definitions
- Creating Target Tables
- Creating source definitions
- Creating a Mapping
- Connecting Transformations
- Transformation Creation
- Importing sources and targets (database objects)
- Importing sources and targets (flat files and XML files)
- Using Transformations
- Aggregator Transformation
- Expression Transformation
- Lookup Transformation (Connected and Un Connected)
- Union Transformation
- Joiner Transformation
- Normalizer Transformation
- SQL Transformation
- Filter Transformation
- Sequence Generator Transformation
- Source Qualifier Transformation
- Router Transformations
- Rank Transformations
- XML Parser Transformation
- XML Generator Transformation
- SQL Override in source qualifier Transformation and lookup Transformation
- Connecting the Target
- Connecting Transformations
- Creating a Mapping
- Completing the Mapping
- Creating a Mapping with Aggregate Values
- Target load order plan
- Mapping wizards
- Reusable Transformation
- WORKFLOW MANAGER
- Creating the Session
- Creating the Workflow
- Using the workflow manager
- Creating Sessions and Workflows
- Configuring Database Connections in the Workflow Manager
- Creating a Reusable Session
- Creating a Workflow
- Running and Monitoring Workflows
- Opening the Workflow Monitor
- Workflow Tasks
- Session
- Assignment task
- Link task
- Post session and Pre-session commands
- Commit points
- Mapping and session parameter
- Pushdown optimization
- WORKFLOW MONITOR
- How to monitor loads
- Uses of Workflow monitor
- Monitoring the jobs
- How to get Session Logs and Workflow Logs
- Real time Questions and Answers
- Exercises for each Transformation
- Datawarehosuing Concepts
SV Soft Solutions is a premier IT Training and Placement Institute. We attempt best quality courses in areas of PeopleSoft, SAP, Oracle, Android, Microsoft, Servicenow, Datawarehousing, Hadoop, Amazon Web services and Tibco. Our online training institute is the best place for you to brush up your technical leading and build a good career ahead in IT related technologies. Our main assets are our Trainers who have minimum 8 years of experience in IT. Our training takes place with well prepared training materials. We provide excellent documentation and preparation materials for learners.
Online Learning Course Benefits
- Industry Expert Trainer
- Real time Scenario
- Doubt session Support
- Topic to Topic Assignments
- Resume Preparation
- Interview Q/A
- Record Sessions
- Detailed Study Material
- 24/7 Support
Data warehousing :
1)Informatica Online Training
2)Cognos Online Training
3)MicroStrategy Online Training
4)Qlikview Online Training
5)MSBI Online Training
6)Teradata Online Training
SAP Modules :
1)SAP HANA Online Training
2)SAP ABAP Online Training
3)SAP BASIS Online Training
4)SAP BO Online Training
5)SAP BODS Online Training
6)SAP BW Online Training ...
Related Courses
