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.

Answer / palzkumar

Determinants define functionality dependencies between Query Items. Use determinant to avoid double counting in de-normalized data

Answer / satya/gunu

=> 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.

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

What is conditional Formatting?

2 Answers   HCL,

---

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers   HCL,

---

What are the types of security?

0 Answers  

---

Diff b/w surrogate Key and Primary Key?

2 Answers   Cap Gemini,

---

how to improve performance in report studio level

1 Answers   Wipro,

---

How can we Maintain the Cube Security by Category level and Dimension level ?

0 Answers  

---

Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?

1 Answers   HSBC,

---

Can u please describe the different types of traps with eg. Thanks

2 Answers  

---

How to pass multiple values from picklist prompt to sub report filter?

2 Answers   IBM, Infosys,

---

what is the use of layout component reference

3 Answers   Satyam,

---

In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,

---

im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?

6 Answers   IBM,

---