Interested to Buy Any Domain ? << Click Here >> for more details...
Q1. Why do we use determinant? Please explain with examples?
Q2. What is new arrive dimensions? Please explain with examples?
Q3. Suppose we have a table which is holding a large number
of records. There are 4 columns which are very frequently
used in the Cognos reports, so can we create indexing on
those 4 columns?
- 2 Answers
- 10376 Views
- Mphasis, I also Faced
- E-Mail Answers
Answer Posted / anirban pal
Q1.
Determinants define functional dependencies between query
items. It is used to avoid double counting of data is
denormalized data sources. Determinants are used to
-Add information about dependencies between columns to avoid
double-counting.
-Specify the granularity of a de normalized query subject to
control grouping and double-counting.
-Uniquely identify the row of data when retrieving text blob
data.
-Override the determinants imported from the data source
that conflict with relationships.
e.g.
Determinant and Dependent
The terms determinant and dependent can be described as follows:
1. The expression X Y means 'if I know the value of X, then
I can obtain the value of Y' (in a table or somewhere).
2. In the expression X Y, X is the determinant and Y is the
dependent attribute.
3. The value X determines the value of Y.
4. The value Y depends on the value of X.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What are types of batch available in cognos?
Suppose you run a report with empty data, how will you inform the end user that it has no data while running the report in report studio? Is it possible, if so how?
What is a Transformer?
what is hints in cognos and where we use it.
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What do you understand by the term 'aggregate cache'?
what is the main advantage of impromptu over cognos reportnet?
How can we create a dynamic column name in cognos?
can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr
What are all the types of indexes in Cognos?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
what is the role of cognos comsultant?what actually it means?pls reply
How to generate cubes in cognos?
What is a Framework manager?
