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 [...]

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 [...]

  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 [...]

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. Share Me!Blog this!Recommend on FacebookShare [...]

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.  [...]

  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: Share Me!Blog this!Recommend on FacebookShare on LinkedinTweet about [...]

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. Share Me!Blog this!Recommend on FacebookShare on LinkedinTweet about itSubscribe [...]