what are determinants?
Answers were Sorted based on User's Feedback
Answer / pagu
Determainants are used for
-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.
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / palzkumar
Determinants define functionality dependencies between Query Items. Use determinant to avoid double counting in de-normalized data
Is This Answer Correct ? | 1 Yes | 0 No |
=> Determinants reflect granularity by representing subsets or groups of data in a query subject and used to ensure correct aggregation of this repeated data.
=> Determinants are most closely related to the concept of keys and indexes in the data source and are imported based on unique key and index information in the data source.
=> By modifying Determinants, you can override the index and key information in your data source,replacing it with information that is better aligned with your reporting and analysis needs.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / madhoo
Determinants are used for to improve the query performance
these are like .... 1. Computer system and network capacity
2. Schema design
3. Database objects
4. Best practices for writing queries
5. Physical storage layout
6. Parallel query and Red Brick Warehouse configuration
computer host loaded correctly and network traffic problem
should be overcome....
A well designed Schema has most effect on query performance...
Database object give good performance .....those are Indexes
and predefined objects...
There are so many ways to write query on a logic...but with
the help of best practices only we can write well
performanced query.
.........
Any question on cognos and Sql .....let me wake up for
them at Cognos.madhoo@gmail.com
Is This Answer Correct ? | 3 Yes | 3 No |
If anyone need COGNOS 8 Certification Dumps of any "COG - Code", u can get from S_Cog@Yahoo.Com, i scored 100 % with these Dumps
what is physical layer and presentation layer?
Can we use 2 packages in report studio at a time is there any alternative for this Thanks Nithin
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
How we check the errors before running the report?
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 is the diff between Drill through reports and Master detail reports?
What are the types of catalogs in cognos?
what was the actual purpose of portfolio in cognos ?
What is Model Versioning or Versioning in Cognos Framework Manager?
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
What is RenderVariable?