Datawarehouse Architect

I have passed OBIEE 11g Certification (1z0-591) with 94% http://mkashu.blogspot.in/2013/12/obiee-11g-dumps.html

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

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  

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

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 a...

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