DATA WAREHOUSING
INFORMATICA:
Informatica 8.1
Overview
Introduction to Informatica
Informatica Architecture
Tools and their roles
Power Center Vs Power mart
Informatica Server Setup
Informatica Repository server setup
Repository server Administration console
Repository Manager
Informatica Designer
Introduction to designer
Logon to designer
Designer tools
Defining Sources
• Database as a source
• Flat Files as a sources
Defining Targets
Mapping Introduction
Ports
Designer Tools
• Source analyzer
• Warehouse Designer
• Transformation Developer
• Mapplet Designer
• Mapping Designer
Workflow Manager
Setting up Informatica Server for Repository
Task Developer Tool
Workflow Designer Tool
Setting properties of Session Task
Workflow Monitor
Types of Transformations
• Active Transformations
• Passive transformations
Source Qualifier Transformation
Filter Transformation
Sorter Transformation
Router Transformation
Union Transformation.
Rank Transformation
Expression Transformation
Aggregator Transformation
Sequence Generator Transformation
Joiner Transformation
Normalize Transformation
XML source qualifier Transformation
Stored procedure Transformation
Look up Transformation
Update strategy Transformation
Transaction Control Transformation
SCD Implementation 1,2,3
Parameter& Variables
Scheduling
COGNOS:
FRAMEWORK MANAGER TOPICS
CH 01 – Introduction
1. Define Framework Manager and its Purpose
2. Architecture
3. Objects:
• Projects
• Models
• Namespaces
• Packages
• Dimensions
• Query Subjects
• Query Items
4. Project Page:
• Project Viewer
• Explorer Tab
• Diagram Tab
• Dimension Map Tab
• Properties Pane
• Summary Pane
• Search Pane
CH 02 - Designing Project
1. Create a new Project
2 Import Metadata
3. Export Metadata
4. Create a Package
5. Publish Package
CH 03 – Relational Metadata
1. Cardinality
2. Verifying Relationships
3. Joins:
• Inner join
• Left Outer join
• Right Outer Join
• Full Outer Join
CH 04 – Verify a Model
1. Fix Invalid Objects
2. Fix Invalid Relationship
3. Invalid Aggregation Rules
4. Unsupported Prompts
5. Inferred Roles
6. Re-evaluate
CH 04 – Dimensions
1. Create a Regular Dimension
2. Specify Roles
3. Create a Measure Dimension
4. Convert Measure into query item
5. Test a Dimension, Query Subject
6. Convert Regular dimension into a query subject
CH 05 – Query Subject
1. Create a Query Subject
2. Modify a query Subject:
• Add item to a Query Subject
• Calculations
• Filters
• Test Query Subject
• Edit the SQL
CH 06 – Query Set
• Union
• Intersect
• Except
• Union all
• Intersect all
• Except all
CH 07 - Business Rules
1. Create Calculation
2. Filters
3. Using Prompt values to filter data
4. Create a parameter map
CH 08 – Organizing the Model
1. Use Shortcuts
2. Create a Folder or Namespace
3. Create Query item folder
4. Create a measure folder
CH 09 - Expression Editor
1. Operators
2. Summaries
3. Constants
4. Constructs
5. Business Date/Time Functions
QUERY STUDIO TOPICS
CH 01 – Introduction
1. Adhoc Reporting Vs Stand Alone Reporting
2. Query Studio Interface
3. Open the web portal
CH 02 – Sample Report
1. Create a report
2. Add Data
3. Save the report
4. Run the report
5. Open an Existing Report
CH 03 – Run Reports
1. Run with prompts
2. Run with all data
3. Preview reports with no data
4. Preview reports with limited data
5. View reports in PDF/CSV/XML/EXCEL formats
CH 04 – Report Types – List Report
1. Insert columns
2. Change the data format
• Numeric data
• Text
• Date
3. Format a column
4. Move a column
5. Add title
Grouped List Report
1. Create Section
2. Group
3. U ngroup
4. Collapse Group
5. Expand Group
6. Filters
7. Combine Filters
CH 05 – Cross Tab Report
1. Create Cross Tab
2. Add Data
3. Swap
CH 06 – Chart Report
1. Create Column Charts
2. Types of Charts
CH 07 – Working with Data
1. Sort
2. Calculation
3. Summarize
4. Prompt
5. Custom Group
6. Turn Off Automatic Summarization
CH 08 – Changing the appearance of Report
1. Apply a Template
2. Change Title
3. Format Text and Data
4. Format Borders
5. Highlighting Key information by defining conditional styles
CH 08 – Drill
1. Drill Up
2. Drill Down
REPORT STUDIO TOPICS
CH 01 – Introduction
1. Architecture of Report Studio
2. Report Studio User Interface:
• Insertable Objects Pane
• Explorer Bar
• Properties Pane
• Work Area
CH 02 – Types of Reports
1. Blank
2. List Reports
3. Cross Tab
4. Chart
5. Repeater Table
CH 03 – List Report
1. Add Data
2. Filter
3. Calculate
4. Format Data
5. Group
6. Total
7. Conditional Highlighting
CH 04 – Cross Tab Report
1. Add Data
2. Nest Data
3. Calculate
CH 05 – Chart Report
1. Create Chart Report
2. Chart Types
3. Combine a Chart and List Report
CH 06- Repeater Table
1. Create a Repeater Table Report
2. Repeaters
CH 07 - Formatting a Report
1. Add header and Footer
2. Add Borders
3. Add Text
4. Specify the Font
5. Add color
6. Insert an Image
7. Reorder Columns
8. Rename a Column
9. Inserting Other Objects
10. Swap Rows and Columns
CH 08 – Prompts
1. Use Build Prompt Page Tool
2. Build Your Own Prompt and Prompt Page
• Text Box Prompt
• Value Prompt
• Select and Search Prompt
• Date Prompt
• Time Prompt
• Date and Time Prompt
• Interval Prompt
• Tree Prompt
• Generated Prompt
3. Create a parameter to produce a Prompt
4. Insert Prompt directly into the report page
CH 09 – Working with Queries
1. Query
2. Join:
• Equi Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
3. Union
4. Intersect
5. Except
6. SQL
CH 10 - Working with Existing Reports
1. Defining Conditions
2. Create a Drill Through Report
3. Drill Up/ Drill Down
4. Master –Detail Relationship
5. Bursting Reports
COGNOS CONNECTION TOPICS
CH 01 – Introduction
1. Architecture
2. Elements on the Screen
CH 02 – Manage Public Folders
1. Organize Folders and Packages
2. Run a Report
3. View Report
4. Export a Report into other Format
BUSINESS OBJECTS:
OLAP & Presentation using Business Objects:
Informatica 8.1
Overview
Introduction to Informatica
Informatica Architecture
Tools and their roles
Power Center Vs Power mart
Informatica Server Setup
Informatica Repository server setup
Repository server Administration console
Repository Manager
Informatica Designer
Introduction to designer
Logon to designer
Designer tools
Defining Sources
• Database as a source
• Flat Files as a sources
Defining Targets
Mapping Introduction
Ports
Designer Tools
• Source analyzer
• Warehouse Designer
• Transformation Developer
• Mapplet Designer
• Mapping Designer
Workflow Manager
Setting up Informatica Server for Repository
Task Developer Tool
Workflow Designer Tool
Setting properties of Session Task
Workflow Monitor
Types of Transformations
• Active Transformations
• Passive transformations
Source Qualifier Transformation
Filter Transformation
Sorter Transformation
Router Transformation
Union Transformation.
Rank Transformation
Expression Transformation
Aggregator Transformation
Sequence Generator Transformation
Joiner Transformation
Normalize Transformation
XML source qualifier Transformation
Stored procedure Transformation
Look up Transformation
Update strategy Transformation
Transaction Control Transformation
SCD Implementation 1,2,3
Parameter& Variables
Scheduling
COGNOS:
FRAMEWORK MANAGER TOPICS
CH 01 – Introduction
1. Define Framework Manager and its Purpose
2. Architecture
3. Objects:
• Projects
• Models
• Namespaces
• Packages
• Dimensions
• Query Subjects
• Query Items
4. Project Page:
• Project Viewer
• Explorer Tab
• Diagram Tab
• Dimension Map Tab
• Properties Pane
• Summary Pane
• Search Pane
CH 02 - Designing Project
1. Create a new Project
2 Import Metadata
3. Export Metadata
4. Create a Package
5. Publish Package
CH 03 – Relational Metadata
1. Cardinality
2. Verifying Relationships
3. Joins:
• Inner join
• Left Outer join
• Right Outer Join
• Full Outer Join
CH 04 – Verify a Model
1. Fix Invalid Objects
2. Fix Invalid Relationship
3. Invalid Aggregation Rules
4. Unsupported Prompts
5. Inferred Roles
6. Re-evaluate
CH 04 – Dimensions
1. Create a Regular Dimension
2. Specify Roles
3. Create a Measure Dimension
4. Convert Measure into query item
5. Test a Dimension, Query Subject
6. Convert Regular dimension into a query subject
CH 05 – Query Subject
1. Create a Query Subject
2. Modify a query Subject:
• Add item to a Query Subject
• Calculations
• Filters
• Test Query Subject
• Edit the SQL
CH 06 – Query Set
• Union
• Intersect
• Except
• Union all
• Intersect all
• Except all
CH 07 - Business Rules
1. Create Calculation
2. Filters
3. Using Prompt values to filter data
4. Create a parameter map
CH 08 – Organizing the Model
1. Use Shortcuts
2. Create a Folder or Namespace
3. Create Query item folder
4. Create a measure folder
CH 09 - Expression Editor
1. Operators
2. Summaries
3. Constants
4. Constructs
5. Business Date/Time Functions
QUERY STUDIO TOPICS
CH 01 – Introduction
1. Adhoc Reporting Vs Stand Alone Reporting
2. Query Studio Interface
3. Open the web portal
CH 02 – Sample Report
1. Create a report
2. Add Data
3. Save the report
4. Run the report
5. Open an Existing Report
CH 03 – Run Reports
1. Run with prompts
2. Run with all data
3. Preview reports with no data
4. Preview reports with limited data
5. View reports in PDF/CSV/XML/EXCEL formats
CH 04 – Report Types – List Report
1. Insert columns
2. Change the data format
• Numeric data
• Text
• Date
3. Format a column
4. Move a column
5. Add title
Grouped List Report
1. Create Section
2. Group
3. U ngroup
4. Collapse Group
5. Expand Group
6. Filters
7. Combine Filters
CH 05 – Cross Tab Report
1. Create Cross Tab
2. Add Data
3. Swap
CH 06 – Chart Report
1. Create Column Charts
2. Types of Charts
CH 07 – Working with Data
1. Sort
2. Calculation
3. Summarize
4. Prompt
5. Custom Group
6. Turn Off Automatic Summarization
CH 08 – Changing the appearance of Report
1. Apply a Template
2. Change Title
3. Format Text and Data
4. Format Borders
5. Highlighting Key information by defining conditional styles
CH 08 – Drill
1. Drill Up
2. Drill Down
REPORT STUDIO TOPICS
CH 01 – Introduction
1. Architecture of Report Studio
2. Report Studio User Interface:
• Insertable Objects Pane
• Explorer Bar
• Properties Pane
• Work Area
CH 02 – Types of Reports
1. Blank
2. List Reports
3. Cross Tab
4. Chart
5. Repeater Table
CH 03 – List Report
1. Add Data
2. Filter
3. Calculate
4. Format Data
5. Group
6. Total
7. Conditional Highlighting
CH 04 – Cross Tab Report
1. Add Data
2. Nest Data
3. Calculate
CH 05 – Chart Report
1. Create Chart Report
2. Chart Types
3. Combine a Chart and List Report
CH 06- Repeater Table
1. Create a Repeater Table Report
2. Repeaters
CH 07 - Formatting a Report
1. Add header and Footer
2. Add Borders
3. Add Text
4. Specify the Font
5. Add color
6. Insert an Image
7. Reorder Columns
8. Rename a Column
9. Inserting Other Objects
10. Swap Rows and Columns
CH 08 – Prompts
1. Use Build Prompt Page Tool
2. Build Your Own Prompt and Prompt Page
• Text Box Prompt
• Value Prompt
• Select and Search Prompt
• Date Prompt
• Time Prompt
• Date and Time Prompt
• Interval Prompt
• Tree Prompt
• Generated Prompt
3. Create a parameter to produce a Prompt
4. Insert Prompt directly into the report page
CH 09 – Working with Queries
1. Query
2. Join:
• Equi Join
• Left Outer Join
• Right Outer Join
• Full Outer Join
3. Union
4. Intersect
5. Except
6. SQL
CH 10 - Working with Existing Reports
1. Defining Conditions
2. Create a Drill Through Report
3. Drill Up/ Drill Down
4. Master –Detail Relationship
5. Bursting Reports
COGNOS CONNECTION TOPICS
CH 01 – Introduction
1. Architecture
2. Elements on the Screen
CH 02 – Manage Public Folders
1. Organize Folders and Packages
2. Run a Report
3. View Report
4. Export a Report into other Format
BUSINESS OBJECTS:
OLAP & Presentation using Business Objects:
- Supervisor: Creating Repository and Supervisor
- Supervisor: Database connections
- Supervisor: Defining Groups and Users
- Supervisor: Defining Privileges and Profiles for Users
- Supervisor: Broadcast Agents
- Supervisor: Scheduling Users connection sessions
- Designer: Creating and Maintaining Universe
- Designer: Defining Tables & columns as Classes and Objects
- Designer: Creating and Maintaining measures
- Designer: Defining Relations, Formulas, etc.
- Business Object: Defining Query, Reports Type
- Business Object: Formatting Reports
- Business Object: Slicing & Dicing Reports
- Business Object: Drill-Down, Drill-up Reports
- Business Object: Filtering Records, Grouping Records, etc.
DATASTAGE
Contents
· Introduction about Data Stage
· IBM Information Sever architecture
· Datastage within the IBM Information Sever architecture
· Difference between Server Jobs and Parallel Jobs
· Difference between Pipeline Parallelism and Partition Parallelism
· Partition techniques (Round Robin, Random,
- Hash, Entire, Same, Modules, Range, DB2, Auto)
· Configuration file
· Difference between SMP/MPD Architecture
· Data stage components (Server components /Client components)
· Package installer
Data stage Administrator
· Creating project, Editing project and Deleting project
· Permissions to user
· .APT config file
· Environment variable creation, permission
Data stage Director
· Introduction to Data stage Director
· Job Status View
· View logs
· Scheduling
· Batches Creation
Designer
· Introduction about Designer
· Repository
· Palatte
· Type of Links
· File Stages
· Sequential file
· Dataset file
· File set
· Lookup file set
· Difference between Sequential file/Dataset/File set
· Database stages
ü Dynamic RDBMS
ü Oracle Enterprise
ü ODBC Enterprise
ü Stored Procedure
Processing Stages
· Change Capture (caption)
· Compare Stage
· Difference Stage
· Aggregate Stage
· Transformer Stage
· Surrogate Generator Stage
· Join Generator Stage
· Merge Generator Stage
· Lookup Generator Stage
· Difference between Join/Lookup/Merge
· Difference between Join/Lookup
· Remove Duplicates
· Switch
· Pivot
· Modify
· Funnel
DebugginStage
· Head
· Tail
· Pea
· Row Generator
· Column Generator
· Sample
· Job Parameters
Manager
· Introduction about Datastage Manager
· Importing the Job
· Exporting the Job
· Importing Table Definition
· Importing Flat File Definition
· Routines
Containers
· Difference between Local Container and Shared Container
· Local Container
· Shared Container
Job Sequencers
· Arrange job activities in sequencer
· Triggers in Sequencer
· Restability
· Recoverability
· Notification activity
· Terminator Activity
· Wait for file activity
· Start look activity
· Execute command activity
· Nested Condition activity
· Routine activity
· Exception handing activity
· User variable activity
· End loop activity
· Adding Checkpoints
Information Analyzer
· IBM Websphere Information Analyzer overview
· Data profiling process
· Column
· Analysis
· Primary key analysis
· Foreign key analysis
· Cross-domain analysis
· Baseline analysis
· Analysis result publication
· Deleting analysis results
· Reports for information analysis
· Column analysis summary statistics reports
· Baseline analysis reports
· Cross-domain analysis reports
· Primary key reports
· Foreign key analysis reports
Web sphere Quality Stage
· About Date Quality
· Datastage Quality stages
· Investigate stage
· Standardize stage Match Frequency stage
· Unduplicate Match stage
· Reference Match stage
· Survive stage
IBM Information Sever Administration Guide
· IBM Websphere DataStage administration
· Opening the IBM Information Sever Web console
· Setting up a project in the console
· Customizing the project dashboard
· Setting up security
· Creating users in the console
· Assigning security roles to users and groups
· Managing licenses
· Managing active sessions
· Managing logs
· Managing schedules
· Backing up and restoring IBM Information Server.
DOT NET
