✍ Kashif M
Trends

Wednesday, 25 December 2013

1z0-591 exam cleared



I have passed OBIEE 11g Certification (1z0-591) with 94%


http://mkashu.blogspot.in/2013/12/obiee-11g-dumps.html

OBIEE 11g dumps








I have cleared OBIEE 11g certification exam (1z0-591) exam yesterday, It was damn easy when compared to OBIEE 10g certification.

I have referenced oracle PDF and some of the other OBIEE dumps.

I remember some of the question which came in exam. I will publish those question very soon









Download Informatica 9.5 software



I seen many peoples searching to download informatica software.

Just go to https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=12854075

I'm going to download informatica 9.5.1 software for linux 64 bit, so here i go.

Download Informatica 9.5 software
Download Informatica 9.5 software


Download Informatica 9.5 software
Download Informatica 9.5 software


 

Sunday, 17 November 2013

Physical Layer Objects in OBIEE 11g





What are the Physical Layer Objects


1. Database

2. Connection pool

3. Schema folder

4. Tables

5. Columns

6. Keys

Screen shots for your reference





Physical Layer Objects in OBIEE 11g
Physical Layer Objects in OBIEE 11g

Create an Alias in OBIEE





1. A common use of alias is to use the table or column to play simultaneously for several times.

2. A single dimension appears more than one time for more purpose.

3. OBIEE does not support Circular join in BMM layer, so we can overcome from this problem by creating alias table for one of the table in that circular join.

4. OBIEE does not support self join, so we can overcome from this problem by creating alias table.

5. If a fact table having relationship with dimension table on more than one key, then we can create aliases for the dimension table, then we can join fact table to these alias table on different keys.

Steps:

1. Right click on the Physical layer of the table, New objectà Alias.

2. Give the name of the alias , automatically it assigns the columns of the physical table 

3. Even it inherits all the properties of the physical table.

Screen shots for your reference:
Create an Alias in OBIEE
Create an Alias in OBIEE





Create an Alias in OBIEE
Create an Alias in OBIEE


Create an Alias in OBIEE
Create an Alias in OBIEE

How do you create a DSN for OBIEE 11g





DSN – Data Source Name, the name which suggests connecting or relates the database.

Steps to Create DSN:

1. Open control panel and go to Administrative toolsà ODBC Administrator.

2. Go to the second tab “system DSN”.

3. Click on Add and select the driver of the database which you are using currently.

4. Give the Credentials first assign name for the Data Source Name.

5. Give the TNS entry to connect the data source.

6. Database User name and then click test connection.

7. Give the credentials in test connection, user name and password of data base.

8. Check the connection is success or not if yes then click ok.

Screen shots for you reference:






DSN for OBIEE 11g
DSN for OBIEE 11g


DSN for OBIEE 11g
DSN for OBIEE 11g


DSN for OBIEE 11g
DSN for OBIEE 11g
DSN for OBIEE 11g
DSN for OBIEE 11g