DW Informatica Contents

INTRODUCTION TO DATA WAREHOUSING-Informatica

* What is Data warehouse
* Components of Data warehouse
* Decision support systems
* OLTP Systems
* OLTP vs DATA WAREHOUSE
* ODS(operational data store)
* Difference between ODS and DATA WAREHOUSE
* Data Mart
* Difference between Data warehouse and Data Mart
* Difference between Data warehouse and ODS,OLTP
* Data warehousing for OLTP systems
* Data cleansing
* Independent Data warehouse
* Dependent Data warehouse
* Meta data and Data Mining
* OLAP,ROLAP,MOLA

DATABASE DESIGN AND DATA MODELING

* ER Model for transactional processing
* Introduction to Data Modeling
* Entities and Attributes
* What is the use of data modeling in Data warehousing
* Schema
* Star Schema
* Snowflake Schema
* Snowflake Schema(hybrid schema or galaxy schema)
* Fact table
* Dimension tables
* Multi dimension tables
* Grain warehousing tools consideration
* Granularity for the data warehousing

INFORMATICA 8.1 or 8.6

* Introduction of Informatica (power mart and power centre)
* Difference between power mart and power centre
* ETL Architecture
* Data source
* Data targets
* Repository
* Meta data
* Server components
* Client components

INFORMATICA REPOSITORY SERVER

* Administrator password
* Port number

INFORMATICA SERVER ADMINISTRATOR CONSOLE(RSAC)

* Creating Informatica Repository Server(IRS)
* Connecting the server
* Creating repository
* Repository considerations

INFORMATICA REPOSITORY MANAGER

* Creating the workspace(folder)
* Creating the users
* Changing the user passwords
* Creating users groups
* Giving privileges to the users, user groups and folder

INFORMATICA DESIGNER

* Connecting to the designer
* Components of the designer
* Creating DSN(data source name)
* Source, Database
* Accessing the source, definitions to the designer
* Warehouse Designer
* Creating the target tables using warehouse designer
* Generating target table to database
* Mapping designer
* Mapping between the source and target tables
* Transformations between source and target tables

TYPES OF TRANSFORMATIONS

* Source qualifier
* Aggregator
* Filter
* Expression
* Stored procedure
* Lookup
* Sorter
* Joiner
* Router
* Xml source qualifier
* Update strategy
* Normalizer
* Ranking
* Sequencer generator
* Transaction control
* Union
* Custom

Slowly changing dimensions (scd) Mapplets
Cubes and dimensions (creating star schema)
Reusable transformations Debugger
Working with mapping using debugger
Data Profiling
Variable and Parameters
New features in power centre 8.1
WORKFLOW MANAGER
Components of workflow manager
Types of tasks

* Session
* E-mail
* Command

Creating workflow
Scheduling the workflow
Creating connections
Assigning connection values to the sessions
Creating server (informatica server)
Assigning server to workflow
Workflow monitor
Session logs
Workflow logs
COGNOS EP SERIES (OLAP TOOL)
IMPROMPTU ADMINISTRATOR:
What is a catalog
Types of catalog

* Personal
* Distributed
* Sheared
* Secured

Creating a catalog
Working with different catalogs
Creating and managing folders
Defining the classes and user privileges
Generating query definition files (IQD)
Creating hot files
Generate the reports, tables into folders
Data integration between reports
Snap shots
Integrating reports with hot files
Generating different types of reports

* Simple list
* Grouped list
* Cross tab reports
* Grouped cross tab
* Stored procedures
* Blank
* Form letters
* Mailing labels

Generating reports to transformer
POWERPLAY TRANSFORMER:

* Using IQD file or any other database source
* Creating dimensions and measures
* Generating the categories
* Creating cubes and manipulating cube properties

POWERLAY FOR WINDOWS:

* Formatting and printing reports
* Drill down drill up
* Slicing and Dicing
* Exporting reports
* Portfolio
* Generating reports into different formats

COGNOS REPOTNET

* Introduction to Cognos reportnet
* Architecture
* Framework Manage
* Metadata Modeling
* Package Development
* Package Import and Export
* Query Studio
* Report Studio-Basics
* Server Administration Environment
* ReportNet Adminstration Environment
* Report studio-advanced
* Administration
* Security

BUSINESS OBJECTS 6.5:(OLAP TOOL)
BO SUPERVISOR

* Creating repository
* Types of domains
* Creating supervisor
* Creating user and deleting users
* Database connections defining groups
* Giving privileges and profiles to the users
* Time stamp
* Logging onto different users

DESIGNER:

* Connecting to database
* Creating connection
* Extracting tables from database
* Inserting joins
* Alias, context and cordiality
* Creating the universe
* Exporting universe to supervisor
* Checking Integrity

BUSINESS OBJECTS:

* Generating report from universe
* Generating report from freehand sql
* Generating report from external files
* Graphical reports
* Foltering the data
* Getting data from different sources
* Integration of data from different sources
* Drill up and Drill down
* Slice and dice
* Export documents to supervisor
* Automatic refresh to the report

WEB INTELLIGENCE (WI):

* Installing server products
* Configuration of WI server
* Working with WI
* Creating documents
* Personal documents
* Corporate documents
* Inbox documents
* Drill up and Drill down
* Expand mode and compact mode
* Downloading the reports
* Saving and sending reports to users
* Generating password and changing the home page style
* Types of document formats
* Difference between Info view and Web Intelligence
* Introduction to web panel
* Types of web panel reports
* Java applets
* Activex controls

DATASTAGE 7.5
Data stage Administrator

* Server properties
* Datastage project Administration
* Adding projects
* Deleting projects
* Cleaning up project files
* NLS Configuration
* Project export option
* Project import option

Datastage Director

* Introduction to Datastage Director
* Datastage director window
* Jobs status view
* Datastage director options
* Limits page
* View page
* Priority page
* Running Datastage jobs
* Validating a job
* Running a job
* Stopping a job resetting a job