✍ 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










Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) About Kashif (1) BI Apps Installation (1) BI Publisher (2) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) mkashu (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)