Interested to Buy Any Domain ? << Click Here >> for more details...
what are determinants?
- 4 Answers
- 10742 Views
- College School Exams Tests, IBM, I also Faced
- E-Mail Answers
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 |
Hi Techies, I got an issue so need your advice here. I have created a report in Report Studio and it's having 2 columns which are having long text as a value (BLOB data type). Report is displaying entire text items in HTML format, but when I'm exporting it into EXCEL it's give me ##########. How to correct (wrap) it in Excel? so when end users they are directly running that report in Excel so instead of seeing ######### for long text items they should see the entire text items in those columns. Please advice!
how can we improve performance of the reports?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
How do you test the performance of a report?
In an existiing Framework model, how will you add a new column to the existing table?
How can we give the same color for alternate(1,3,5.... and 2,4,8...) cells in a column?
which table we load first in DW. dimension or fact? why?
4 Answers IBM, JPMorgan Chase,
How can we create a dynamic column name in cognos?
what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly
How to pass multiple values from picklist prompt to sub report filter?
How can we publish package to QA environment not cognos connection?(if we have two URL one cognos connection and qa environment how can we publish package to qa?)Please anybody give me the answer.
What is content Manager?
Teradata 
