Datawarehouse Architect

Select the Shared logon check box if you want all users whose queries use the connection pool to access the underlying database using the same user name and password which given in the connection pool. If this option is selected, then all connections to the database that use the user name and password specified in the connection pool, even if the user has specified a database user name and password in the DSN (or in user configuration). If this option is not selected, connections through the connection pool use the database user ID and password specified in the DSN or in the user profile. Screen shots for your reference: Shared Log On option in OBIEE 11g

1. Go to the location D:\11G\instances\instance1\config\OracleBIServerComponent\coreapplication_obis1 2. and find the NQSConfig.INI file, move down to the section “Query Result Cache Section” Enable =yes. 3. Login to Console ( http://localhost:7001/EM ) 4. Go to Business Intelligence -> Core Application -> Select Capacity Management tab -> Select Performance tab below capacity management tab -> Click 'Lock and Edit Configuration' -> Deselect the 'Cache enabled' option -> Click Apply -> After that Click 'Activate Changes' 5. Restart the services. Screen shots for your reference: Cache in OBIEE 11g Cache in OBIEE 11g

Connection pool is defined as the connection between the data source and Oracle bi server. Connecting database using the interface like OCI, odbc, etc. to the Admin tool RPD to serve the information of data. Screen shots for Your Reference:

1. Relationship between the logical tables was expressed by logical joins in BMM layer. 2. Logical joins express the cardinality relationships between logical tables and are a requirement for a valid business model.  3. Specifying the logical table joins is required so that Oracle BI Server can have the necessary metadata to translate logical requests against the business model into SQL queries against the physical data sources. Logical joins help Oracle BI Server understand the relationships between the various pieces of the business model.  4. When a query is sent to Oracle BI Server, the server figures out how to construct physical queries by examining how the logical model is structured.  5. Examining logical joins is an integral part of this process.  6. The Administration Tool considers a table to be a logical fact table if it is at the “many” end of all logical joins that connect it to other logical...

1. Complex Join in the BMM layer represents the relationship between the logical tables and its columns. 2. It makes the best decision about sql request to generate based on the logical query request. 3. Use of complex joins, can create one to many relationships and not the logical foreign key. 4. We can’t use the expression builder in the complex join because it will be grey out. You can only use the types of joins like inner or outer. 5. Logical joins are automatically created if both of the following statements are true: 6. You create the logical tables by simultaneously dragging all required physical tables to the Business Model and Mapping layer. 7. The logical joins are the same as the joins in the Physical layer 8. Logical tables in a BMM layer can have multiple logical tables sources (LTS). Complex join actually is an intelligent join between LTSs of two logical tables in BMM Layer.

Normalized: It is the process of effectively organize the data in to the database. Eliminating redundant data storing the same data for more times. Stores only related data into the database. It is the process of structuring relational database schema such that most ambiguity is removed. De – Normalized: It is process to increase the database performance. It involves adding redundant data to a normalized database to reduce certain types of problems with database queries that combine data from various tables into a single table.

OLTP: Online transactional transaction processing It is characterized by large number of rows of data’s per second. For each and every transaction of data will get store for time to time. In OLTP database there is detailed and current data, and schema used to store transactional databases is the entity model (usually 3NF). All the transaction in OLTP normally will consider as Normalized. OLAP: Online Analytical Processing It is characterized by very low volume of transactional data. Normally OLAP will consider as De-normalized. All the transactions are aggregated to view in very less rows of data. In OLAP database there is aggregated, historical data, stored in multi-dimensional schemas (usually star schema).