Informatica Basics...

Hi Frens...

Lets go thru some Informatica(INFA) basics and lets see some other important things....

What are the differences between Power Center and  Power Mart???

• Power Mart is a departmental version of Informatica for building, deploying, and managing data warehouses and data marts. 

• Power center is used for corporate enterprise data warehouse and power mart is used for departmental data warehouses like data marts. 

• Power Center supports global repositories and networked repositories and it can be connected to several sources. Power Mart supports single repository and it can be connected to fewer sources when compared to Power Center. 

• Power Mart can extensibily grow to an enterprise implementation and it is easy for developer productivity through a code less environment.

Working with Joins on Admin Tool...

Hey All...
Joins is a very common thing and most of the people don't give much attention how and when we use Physical Joins and when we use coplex joins... Lets c how and why of joins.....


Primary-Foreign Key Joins
The PK-FK joins are generally used in Physical Layer. These joins are required to form the physical query using which the data from the underlying DB will be pulled. These are the joins between the PK FK columns in the facts and dimensions. These joins are used between defined columns between 2 tables. As shown in the pic below the jons are defined between 2 columns which can be seen from the expression.

Physical Foreign Key Joins Diag.

Differences Between Siebel Analytics & OBIEE

Hi...
I have heard this question multiple times from many people. So let me share the answer with u guys....

Oracle BI Answers-Based Metadata Dictionary Feature

This feature enables administrators to analyze metadata repository statistics in Oracle BI Answers. The OBIEE server can generate metadata dictionary which describes the metrics contained in a rep and the attribs of rep objects. Its an XML doc.
In OBIEE this can be accessed directly from BI Answers selection pane where specific metadata information will be shown to guide report construction. Once this BI Answers based functionality is been enabled an icon will appear next to each Subject Area, Table name, and Column shown in the selection pane for that Subject Area. Clicking on the icon will open up a specific Metadata Dictionary page to show information for that element and links to related repository information

Clustering & Load Balancing Of BI Server

Hi....
I have read something and wud like to share that with u... Mite help u.... have a look...

Clustering capability  allows for the deployment of a multi-server environment to better manage large volumes of users and to provide high availability.


TYPES OF CLUSTERS

Describes the different types of computer clusters.

High-Availability (HA)
The main function of High-Availability clusters is to improve the availability of the computing system in case of a breakdown. In HA clusters not all nodes may be contributing to the operation at a given moment. Some of the nodes are redundant standby nodes that operate only in case of the failure of the main node. This connfiguration is referred to as ‘active-passive’ deployment.

Back to basics.....

Hello again...

In some previous we have discussed about the Dimensional Modelling, Datawarehousing, Facts and Dimensions etc...
But where and how are all these things used and How are they related to Analytics????

Actually Analytics is a reporting tool which aims to provide users the reports as per their requirements without much efforts and in less time.  So, to fullfill all these requirements we use the above mentioned terms....

Analytics generally makes use of DWs for storing data. The DWs have Dimension modelling done in place which help users with a fast response time. Means when a user tries to run the reports and fetch data then all this is done is seconds...

OBIEE config Tags explained...

Hi All

I was just going through a document and it had the tags that we use in the OBIEE config files and other files. This can be of real good help for everybody and would like to share it with all the readers.
Below is the link:

Whts Dimensional Modelling...??

Hi again..

If we remember prev we have discussed about the 2 common industry techniques viz. Datawarehousing & Dimensional Modelling. So i have brought a brief overview of wht exactly is dimensional modelling(DM)...

So lets start....

Whats DM????

Dimensional modelling is a logical design technique used for DWs.

Lets understand it in a diff way. If a user want to c some report of dollar value with region for an eg. so what will he want to c???
He wud like to c a column dollar with region...
Based on the user requirement the data needs to be segregated in facts and dimensions and the data should have a proper relationship between the fact & the dimension so that the user can c the data is the desired format.