Skip to main content

Posts

What is a dimension table in data warehousing

By
A category of information. 1. It relates the context of text of information for a fact table measure. 2. Dimension table have Surrogate key, one or more other fields that compose the natural key (nk), primary key and set of Attributes. 3. Size of Dimension Table is smaller than Fact Table. 4. In a schema more than one number of dimensions is presented than Fact Table. 5. Surrogate Key is used to prevent the primary key (pk) violation (to store historical data). 6. Values of fields are in numeric and text representation.
Post a Comment
Read more

What is a Fact Table in Data warehousing

By
A fact table that contains the measure of values (Numeric Data of business). For example, sales amount would be such a measure. This measure is stored in the fact table with the appropriate granularity. For example, it can be sales amount by store by day. In this case, the fact table would contain three columns: A date column, a store column, and a sales amount column. In Oracle Business Intelligence Fact table have foreign key to get connect with the dimension tables. 1. It provides measure of an entity. 2. Measurement is the amount (aggregate values). 3. Structure of Fact Table - foreign key (fk), Degenerated Dimension and Measurements. 4. Size of Fact Table is larger than Dimension Table. 5. In a schema less number of Fact Tables observed compared to Dimension Tables. 6. Compose of Degenerate Dimension fields act as Primary Key. 7. Values of the fields always in numeric or integer form.
Post a Comment
Read more

Instance Config.xml in OBIEE 11g

By
Where is Instance Config.xml located and what is the use of this File Location of instance Config.xml File is D:\11G\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 1. It is used to know the information about which catalog DSN is using in the oracle Bi server. 2. It is used to hold the maximum size of enterprise managers logging information, 3. It is used to know the information about the presentation services url 4. It is used to know the information about the port numbers. 5. Alerts configuration settings 6. Action frame work url configuration 7. Expiry minutes or time information of security like users. 8. Result row limits. 9. Pivot table view configuration 10. Table view configuration
Post a Comment
Read more

NQS CONFIG.INI in OBIEE 11g

By
In NQS CONFIG.INI file 1. Option to edit the section repository. 2. Query Result Cache Section 3. General Section 4. Time Display format 5. Memory space configuration 6. Initialization block configuration 7. Security section configuration 8. Server configuration 9. DB hints. 10. Logging support level 11. High Availability Section 12. Dynamic Library Section 13. Usage Tracking Section 14. Connection pool configuration 15. Query optimization 16. Aggregate Persistence Section 17. Java host Section 18. Data mart Automation Section
Post a Comment
Read more