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
- 10289 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
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
What are the components of the report studio?
What are the advantages of using cognos sql?
how to create measures and dimensions?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
How to deploy from one server to another server?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
what is catalog and types of catalogs in cagnos and which is better?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
Hi All, I have 1.6 years of experience in cognos in India. I always wanted to do a MS program to earn some money in US. But I think I am little late in taking the decision. As If I have to write my GRE it will be August or September of 2012 and will have to apply for fall 2013 as fall 2012 admissions are almost done now. So my concern is how will be my career do if my MS is at this stage,. i,.e. 3 years experience in Cognos and 2 years MS program in and again looking for job in U.S. Have I been too late in taking the call? I heard that MIS (Managing Information Systems) is having very good placements now. So guys, please advice me in taking the decision to have a good career and also in terms of earning money as I have few financial problems to solve (which I am hoping to solve when I get job in US after completion of my MS program). Thanks a lot friends. I really appreciate and thank one and all for their valuable comments in this site.
is there any difference between operational database and data base?if yes what r they?
What are cognos connection initial page components?
Cleared COG-112 with 100% score today. What next certification should i go for?
What is the use of powerplay web viewer in cognos?
