Business Intelligence

Blog for all things about OBIEE, Informatica, DAC, BI Apps, including BI Publisher, technologies and tools.

Showing posts with label Informatica. Show all posts

Friday, December 28, 2012

SCD Type2 Through Informatica with date range

https://docs.google.com/open?id=0ByVBmePwMuhZd01iT3VNd3ZzUWM

Posted by hanu at 4:54 AM No comments:

Email This BlogThis!Share to X Share to Facebook Share to Pinterest

Labels: Informatica

Older Posts Home

Subscribe to: Posts (Atom)

Blog Archive

▼ 2013 (8)
- ▼ April (8)

► 2012 (17)
- ► December (17)

Popular Posts

Degenerate dimension

A Degenerate Dimension is a DIMENSION which exists within the fact table alone - as in a Foreign Key which has no Primary Key. Usuall...
DAC Tasks & Explanation

Step Task Name Descriptiopn Notes 1 Seed Data Configuration a) Task Logical folders One Time Only....
Multiple Fact Reporting on (Non-)Conforming dimensions – Part II

What happens when you want to filter on a non-conforming dimension? When you filter an a non-conforming dimension, you could get a null v...
Security in OBIEE

Types of Security in OBIEE with example Why do we need security in OBIEE? OBIEE is a reporting tool wherein multiple users belonging t...
OBIEE 10g Installation

OBIEE 10g Installation Steps with Screenshots Prerequisites Windows XP Current version of the Java JDK( Java Development Kit ...
Multiple Fact Reporting on (Non-)Conforming dimensions - Part I

There are some questions, which are popping up at the Oracle BI EE Forums regularly. One of those questions is; *** How to model multiple ...
Data Warehouse Design Approaches

Data warehouse design is one of the key technique in building the data warehouse. Choosing a right data warehouse design can save the pr...
Dimensional Modeling

Dimensional modeling (DM) is the name of a set of techniques and concepts used in data warehouse design. Dimensional modeling always us...
SCD Type2 Through Informatica with date range

https://docs.google.com/open?id=0ByVBmePwMuhZd01iT3VNd3ZzUWM
OLTP (Online Transaction Processing)

We can divide IT systems into transactional (OLTP) and analytical (OLAP) systems. OLTP stands for OnLine Transaction Processing. OL...