Scribd
Upload
15 views3 pages

Informatica Data Warehousing Overview

The document discusses concepts related to data warehousing including dimensional modeling, fact tables, and slowly changing dimensions. It also provides an overview of the Informatica data integration tool including its architecture, components, transformations available in the designer tool, and various tasks in the workflow manager. Finally, it lists topics on advanced Informatica concepts and Oracle database concepts including shell scripting and scheduler tools.

Uploaded by

ravitejapannem
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
15 views3 pages

Informatica Data Warehousing Overview

The document discusses concepts related to data warehousing including dimensional modeling, fact tables, and slowly changing dimensions. It also provides an overview of the Informatica data integration tool including its architecture, components, transformations available in the designer tool, and various tasks in the workflow manager. Finally, it lists topics on advanced Informatica concepts and Oracle database concepts including shell scripting and scheduler tools.

Uploaded by

ravitejapannem
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Data Warehousing Concepts:

Introduction to Data Warehousing


Introduction to OLTP, and OLAP Systems
Architecture of DWH
Data Modelling
Normalization Forms
Dimensional Modelling
Star Schema
Snowflake Schema
Types of Fact Tables (Additive, Semi-Additive, Non-Additive)
Types of Dimension Tables (Confirmed, Junk, Degenerated)
Fact less Fact table
Slowly Changing Dimensions

Informatica:

What is Informatica
Informatica 9x Architecture
Powercenter Integration Service 9
Informatica Server 9.6.1 Install and Configure
Informatica Client Tool 9.6.1 Installation
Informatica Client Tools

List of Transformations in Designer:


Active/Passive
Connected/UnConnected
Source Qualifier
Expression
Aggregator
Filter
Router
Joiner
Lookup
Normalizer
Rank
SQL Transformation
Sequence Generator
Sorter
Stored Procedure
Transaction Control
Union
Update Strategy
XML Transformation

Tasks List
Workflow Manager Overview
Workflow
List of Tasks in Workflow Manager
Session
Command Task
Email Task
Control Task
Event Task
Event Wait Task
Event Raise Task
Decision Task
Assignment Task
Timer Task
Informatica Schedular

Advance Topics
File List / Indirect Load
Mapping Parameters & Variables
Parameter File
Mapplets
Worklets
Constraint-Based Loading
Target Load Plan
User-Defined Function
Import Flat File/XL/XML/CSV Definitions
Capturing Currently Processing Flat file Name
Generating Dynamic Flatfile names
Import Relational Definition
Data Driven Aggregation
Incremental Aggregation
Error Handling Mechanism
Update Override
Update without Update strategy
Dynamic Lookup with real-time example
Validating all the objects in the folder at a time
Bad file Processing
PMCMD command
Slowly Changing Dimension Type 1
Slowly Changing Dimension Type 2 - Effective Date Range
Slowly Changing Dimension Type 2 - Flag Current
Slowly Changing Dimension Type 2 - Version Data
Slowly Changing Dimension Type 3
SCD1 & SCD2 with MD5
Performance tuning (With Real-time Env & Concepts)
Pushdown Optimization (With Real-time Env & Concepts)
Partitioning (With Real-time Env & Concepts)
Incremental/Delta Loading(With Real-time Env & Concepts)
10 Advanced Real-time Lab scenarios

Oracle Concepts:
TOAD tool
DDL Statements
DML Statements
TCS Statements
Joins
Sub Query
Correlated Sub Query
Oracle Analytical functions
Views, Indexes
Rank/Dense Rank
Partitioning
Basic PL/SQL Concepts(Cursors,Triggers,Stored Procedures,Functions)

UNIX : Shell Scripting with Real time Examples

Scheduler
Tidal Scheduling Tool (With Real-time Env & Concepts)

You might also like