Answer Posted / 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

Define the cognos reporting tool?

1105

---

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1958

---

How to deploy from one server to another server?

2541

---

what is power prompt in cognos ep7series?what is the use of this?

3731

---

Why need staging area database for dwh?

1120

---

How to apply securities for reports in cognos connection?

2585

---

What is the metric store database?

1011

---

how you provide security to reports? How you provide security to packages ?

1113

---

What is model filter?

1318

---

write a query to display the departments with no employee?

2019

---

What is dtm?

1216

---

Actually we have 500 users when they run the report display the flage image related country user? How its possible?

2068

---

what is the procedure for scheduling conditional rendering?

2581

---

What do you understand by the term 'aggregate advisor?'

1010

---

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

2101

---