what are determinants?
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
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are all the types of gateway used in Cognos?
Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?
Can you define metrics designer?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
Mention the difference between ‘macros’ and ‘prompt’?
plsreply to me...im interested to do the cgnos certifications relating to report developer.can you suggest me what kind of certifications andwhere cani get (dumps) previous quetions and answers for the certification........
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
1. Explain your project.
What are cognos connection initial page components?
Can you define framework manager?
Can you define bitmap index?
Can you define fan trap?
Can you define folder?
What DB View and Bus View?