What is Index?
Answers were Sorted based on User's Feedback
Index is one of the databse object.it is used to quickly
locate the particular record.
i.e.if a table contains thousand's of record, in which
retrieving the particular record is difficult.so if we
create index in primary key column, we can retrieve
particular record very soon. so we can save the time.
ex.create index indexname for tablename of columnname.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / the who
Index is list of keywords/keys/words that represent a unique
record/tuple.
| Is This Answer Correct ? | 0 Yes | 1 No |
What is the difference between filter & Condition?
What you mean by drill across and what is the difference between drill through, drill across?
How to crate cubes in transformer ?
How can I disable the drill-down for the last level of my dimensional hierarchy ????
Can you define a query subject?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
Define datastores in cognos?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
What is called Cognos powerplay?
It is possible to give 2 query items has measures in cross tab?for ex:row as products,column as year and measure as revenue,sales year....like that.It is possible r not ?If it's possible pls tel me the process....
What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....
Column level security in report