Data Warehouse Training Institute in Gurgaon
Data Warehouse Informatica is one of the most technology in demand in the India. Live Technoworld provides real-time placement assistance focused data warehousing training in Gurgaon. Our data warehousing course includes basic to advanced level. Our data warehousing trainers are data warehousing certified experts and experienced working professionals with hands on real time multiple Data Warehousing projects knowledge. In our data warehousing training program, you will learn Data warehousing concepts, Datawarehouslng Life cycle, Architecture, Data Modelling, Data Modelling Tools, data warehousing real time project.
Informetica 7.1
1. Introduction to Information
Overview
Basic Definitions
Informetica Products
Informetica Architecture
Tools and their roles
Folders-sub Folders
Power Center I Power Malt
2. Informetica Designer–Introduction
Introduction to designer
Designer interfaces
Designer tools
Defining Sources
(i) Database as a source
(ii) Rat Flies sources
Defining Targets
Importing from database
Creating a new target
Creating target database objects 3. Informetica Designer
Mapping Introduction
Source Qualifier
Ports
Mapping Table to Table
Mapping flat File to Table
Connected/Unconnected Transformations
Active and Passive Transformation
Source Qualifier Transformation
SQL Override-Source Qualifier Transformation
Mapping Source Qualifier as Filter
Source qualifier to join Data
Filter Transformation
Expression Transformation
Sequence Generator Transformation
Rank Transformation
Router Transformation
Aggregator Transformation
Joiner Transformation
Stored procedure Transformation (Connected & Unconnected)
Union Transformation
XML Transformation
Mapping Wizards
Implementing Type-I, Type-II, Type-III
Mappings
Reporting tool Cognos or Business Object (BO)
Congos
Report Net with Cognso 8
Architecture
Framework Manager
Metadata Modeling
Package Development
Package Import & Export
Query Studio
Report Studio –Basics
Report Studio -Advanced
Data Stage 7.X
1. Data Stage Administrator
Server Properties
Data Stage Project Administration
Adding Projects
Deleting Projects
Cleaning up Project files
NLS Configuration
Project Expor t Option
Project Import Option
2. Data Stage Director
Introduction to Data Stage Director
Data Stage Director Window
Jobs Status View
Data Stage Director Options
Limits Page
View Page
Priority Page
Running Data Stage Jobs
Validating a Job Running a Job
Stopping a Job
Resetting a Job
Job Scheduling
Deleting a Job
Job Batches
Introduction to Job Batch
Creating a Job Batch
Running a Job Batch
Scheduling a Job Batch
Unscheduling a Job Batch
Monitoring Jobs
The Monitor Window
Showing Unks
Showing (])U Usage
Stage Status Window
3. Data Stage Designer
Importing Table Definitions
Importing Flat Ale Definitions
Designing Server Jobs
Aggregator Stage
Transformation Stage
Annotations
Annotations Descriptions
Shared Containers
Local Containers
Reject Rows
Implementing Router Stage
Data Elements
Routines
Developing Custom Routines
Job Sequencer
Implementing Simple & Complex Jobs
4. Data Stage Manager
Introduction to Data Stage Manager
Importing Table Definitions
Importing Flat File Definitions
Managing the Meta Data Environment
Business Objects (BO)
Read more
Go Back Download Registration