What Is Index Awareness?

1.	What Is Index Awareness?
Answer» Index awareness in a UNIVERSE determines which values in a filter conditions of the queries built from the universe, are replaced by their corresponding indexes or surrogate keys. Values in filter COMES from DIMENSIONS table and you need a JOIN with the fact table to get this value. Index awareness in a Universe determines which values in a filter conditions of the queries built from the universe, are replaced by their corresponding indexes or surrogate keys. Values in filter comes from dimensions table and you need a join with the fact table to get this value.

Answer»

Index awareness in a UNIVERSE determines which values in a filter conditions of the queries built from the universe, are replaced by their corresponding indexes or surrogate keys. Values in filter COMES from DIMENSIONS table and you need a JOIN with the fact table to get this value.

Index awareness in a Universe determines which values in a filter conditions of the queries built from the universe, are replaced by their corresponding indexes or surrogate keys. Values in filter comes from dimensions table and you need a join with the fact table to get this value.

Discussion

No Comment Found

Related InterviewSolutions

How Do You Hardcore Values In A Data Model In Dashboard?
What Are The Different Data Connections That Are Supported In Dashboard Designer?
If You Want To Use Same Layout, Appearance For All The Data Models In Dashboard Designer, How You Can Do This?
What Are The Default Template Categories In Dashboard Data Model?
What Is Query Refresh Or Query Prompt Under Universe Component?
What Is Web Connectivity Components? What Are The Different Component Types?
What Is The Use Of Single Value Component? What Are The Different Styles Of Single Value Component?
What Is Selector Component? What Are The Different Types Of Selector Component?
What Is A Container Component? What Are The Different Types Of Container?
What Are The Different Output Formats In Dashboard?