DW - ETL Informatica & OBIEE Course Contents
Oracle Concepts ( 10.0g )
1. Oracle Objects
2. DDL Statements
3. DML Statements
4. TCS Statements
5. Joins
6. Sub Query
7. Correlated Sub Query
8. Oracle Analytical functions
9. Views, Materialized views
10. PL/SQL
Datawarehouse Concepts
1. Data Warehouse
2. Data Mart
3. OLAP VS OLTP
4. Data Warehouse Architecture (Basic)
5. Data Warehouse Architecture (with a Staging Area)
6. Dimensional Modeling
7. Star Schema
8. Snowflake Schema
9. Dimension
10. Fact
11. Slowly Changing Dimension
12. Hierarchy
13. Confirmed Dimension
14. Fact less Fact
15. Summary / Aggregations table
!6. Change Data capture
E T L Informatica Power Center 8.1
1. Power Center Components
a) Designer
b) Repository Manager
c) Workflow Manager
d) Workflow Monitor
2. Informatica Concepts and O
verview
a) Informatica Architecture.
b) Source Qualifier
DW- ETL Informatica and OBIEE COURSE CONTENTS
---------------------------------------------------
---------------------------------------------------
------------------------------------------
DW - ETL Informatica & OBIEE Course Contents
Page 2 of 4
Proprietary and Confidential
c) Target Qualifier
d) Transformations
e) Mappings
f) Mapplets
g) Sessions
h) Tasks
3. Sources
a) Working with relational Sources
b) Working with Flat Files
4. Targets
a) Working with Relational Targets
b) Working with Flat file Targets
5. Transformations
a) Expression
b) Lookup
c) Sequence Generator
d) Filter
e) Joiner
f) Sorter
g) Procedural
h) Router
i) Aggregator
j) Active and Passive Transformations
k) Update Strategy
l) Data Concatenation
m) Debugging Mappings
6. Mappings & Mapplets
a) Mapping Variables & Parameters
b) Creating Cubes & Dimensions
c) Working with Mapping Wizards
7. Workflow Manger
a) Server Architecture
b) Workflows, Worklets & Sessions
c) Tasks, Assignments, Events, Command etc,
8. Performance Tuning
a) Informatica Tuning (Source, target, mapping & S
ession)
b) Oracle Tuning (Indexes, MV, Explain plan, Tkpro
f & SQL Hints)
9. Project - Case Study
10. Project - Review and Assignment
Distributed systems Scheduling tools:
•
Autosys
•
Autosys
Vs
Informatica Scheduler.
---------------------------------------------------
---------------------------------------------------
------------------------------------------
DW - ETL Informatica & OBIEE Course Contents
Page 3 of 4
Proprietary and Confidential
OBIEE 10.1.3.3.3.
OBIEE 10.1.3.3.3 is a client-server tool for report
ing and analyzing data. The following
subjects are covered:
1. OBIEE 10.1.3.3.3 Installation
2. Concept of Dimensional Modelling
a) Star Schema
b) Snow Flake
c) Fact Table
d) Dimensional Table
3
. OBIEE Architecture
I. Components of OBIEE
a) Oracle BI Presenation Server
b) Oracle BI Server
c) Pop Chart Server
d) Oracle BI Scheduler
e) Admin Tool
4. Different Versions Of Oracle BI and Attributes
5. Oracle BI User Interface
a. Answers
b. Dashboards
c. Views
d. Prompts
e. Variables
f. User and Groups
g. Previllages
h. GoNav
6.
Oracle BI Admin Tool
I. Message flow from Browser to Data warehouse
I. Physical Layer
a) Importing Physical Tables
b) Creation of Physical Joins
c) Configuring Connection Pools
d) Exploring Views
II. Logical Layer
a) Creation of Business Model
b) Creation of Logical Facts
c) Creation of Dimensions
d) Creation of Dimension Hierarchies/Levels
e) Creation of Measures
f) Aggregation Navigation
g) Fragmentation Content & WHERE clause
---------------------------------------------------
---------------------------------------------------
------------------------------------------
DW - ETL Informatica & OBIEE Course Contents
Page 4 of 4
Proprietary and Confidential
III. Presentation Layer
a) Creation of Presentation Catalog
b) Creation of Presentation tables
c) Creation of Presentation Columns
IV. Groups, Users, Repository Variables, Session V
ariables, Initialization
Blocks
7. Enabling Cache
a) Creating iBots
b) Automated Cache Purging using Event Polling
c) Seed Cache
8.
Security
I. Authentication
a) LDAP
b) Database
c) Repository
d) External Table
I I. Authorization
a) Filters, Data Security – GROUP
b) UI Security – WEBGROUPS
9
. Siebel Analytics Time Series Wizard
a) Year Ago, Quarter Ago, Month Ago
10.
OBIEE UI Tricks
11. OBIEE Repository Tricks
12. Real time Project Repositories
13. Recap of the session, important website address
http://www.eoktechnologies.com/DWIS_EOK.pdf
_____________________________OR-----------------------------------------------------
Hayagriva Technologies
Informatica Course Content
www.hayagrivatechnologies.com
INFORMATICA
DATAWAREHOUSING CONCEPTS:
INTRODUCTION TO DATAWAREHOUSING
•
What is Data warehouse?
•
Components of Data warehouse
•
Decision support systems
•
OLTP Systems
•
OLTP vs DATAWAREHOUSE
•
ODS(Operational Data Store)
•
Difference between ODS and
DATAWAREHOUSE
•
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
TOOLS CONSIDERATION:
ERWIN (Data Modeling Tool)
•
Introduction to Erwin
•
Usage of Erwin
•
Physical and Logical Model
•
Creation of Table
•
Forward Engineering
•
Reverse Engineering
•
Complete compare
•
Domains
•
Subject areas
Hayagriva Technologies
Informatica Course Content
www.hayagrivatechnologies.com
•
Relationships
•
Demoralization
•
Data Modeling report generation
•
HTML report
•
RTF report
•
Text report
•
Creating user defined data types
•
Integrating Tables from different users
INFORMATICA 8.6
•
Introduction of Informatica power center
•
ETL Architecture
•
Data source
•
Data targets
•
Repository
•
Meta data
•
Server components
•
Client components
INFORMATICA INSTALLTION
•
SYSTEM REQUIREMENT
•
CREATING DOMAIN
•
CREATING NODE
•
CONFIGURING DOMAIN WITH WEBSERVER
•
ASSIGNING INFORMATICA SERVICES WITH
ACCOUNT
Hayagriva Technologies
Informatica Course Content
www.hayagrivatechnologies.com
INFORMATICA POWERCENTERWEBADMINISTRATOR
CONSOLE
•
Creating Informatica Repository Services
•
Creating integrated services
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
Hayagriva Technologies
Informatica Course Content
www.hayagrivatechnologies.com
•
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
•
Cubes and Dimensions(creating star schema)
•
Slowly Changing Dimensions(SCD) Mapplets
•
Reusable transformations Debugger
•
Working with mapping using Debugger
Hayagriva Technologies
Informatica Course Content
www.hayagrivatechnologies.com
•
Data Profiling
•
Variable and Parameters
•
New Features in power centre 7.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
•
Assigning server to workflow
•
Workflow monitor
•
Session logs
•
Workflow logs
Conclusion:
•
Resume Preparation
•
Real Time Scenarios
•
Documents
http://www.hayagrivatechnologies.com/Informatica.pdf
I have read your blog, it was good to read & I am getting some useful info's through your blog keep sharing... Informatica is an ETL tools helps to transform your old business leads into new vision. Learn Informatica course in Chennai from corporate professionals with very good experience in informatica tool.
ReplyDeleteHi Admin,
ReplyDeletePretty interesting article, your article helped me to understand Informatica ETL tool. I am planning to start my career in Informatica business analytics. Informatica Training in Chennai | Informatica Course in Chennai
I have read your blog its very attractive and impressive. I like it your blog.
ReplyDelete.Net Online Training
Dot Net Online Training | ASP.NET Online Training
I would like to say thanks to share this valuable information about Angularjs Online Training Bangalore
ReplyDeleteThis is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.I like it and help me to development very well.Thank you for this brief explanation and very nice information.
ReplyDeleteMicrostrategy Training in Chennai
Microstrategy Training
I am commenting to let you know what a terrific experience my daughter enjoyed reading through your web page.
ReplyDeletefire and safety course in chennai
Pretty post! This is very interesting with useful content and I was very impressed with posting your written style. Good job keep it up.
ReplyDeleteSpark Training in Chennai
Spark Training
Oracle Training in Chennai
Pega Training in Chennai
Linux Training in Chennai
Social Media Marketing Courses in Chennai
Power BI Training in Chennai
Tableau Training in Chennai
Excel Training in Chennai
Oracle DBA Training in Chennai
Spark Training in Valachery
And indeed, Iam just always astounded concerning the remarkable things served by you. Some four facts on this page are undeniably the most effective I have had.
ReplyDeleteTop oracle training in chennai
|oracle training in chennai | oracle training in chennai | Advanced oracle Training Institute in Chennai
Top Oracle PL/SQL Training in Chennai
|oracle training in chennai | oracle training in chennai | Advanced oracle Training Institute in Chennai
Top Oracle DBA Training in Chennai
|oracle training in chennai | oracle training in chennai | oracle Training Institute in Chennai
Top Oracle SQL Training in Chennai
|oracle training in chennai | oracle training in chennai | Advanced oracle Training Institute in Chennai
Powerful contents are giving more ideas Regarding Technically...and it's used to enhance my knowledge...Keep doing this help ever
ReplyDeleteJava training in chennai | Java training in annanagar | Java training in omr | Java training in porur | Java training in tambaram | Java training in velachery