3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?
Answer Posted / vishal
Cognos Sql: This Sql is genreated by cognos on the behaf of
your query. It is good for your own calculation and for the
performance tunning also.
Native Sql: This is Sql based query which has typical
database format and funcatons. All the caculation done at
database only.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
Can you define materialized view?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is difference between content store and content manager? How can create users and permissions in cognos? Explain the different types of views used in cognos. hi, i am searching job in cognos and datastage, does any
can provide me the real time experieced scenerios and
questions related to cognos and datastage projects, so if
anyone provide me the documents related this can very
helpful to me, my mail id is tchiru01@yahoo.com What is the model filter? hi, this is harish. i had finsihed cognos course recently.can
some one help in the area of project explination, interview
questions,real time scenarious....this is my maild id
nanagupta907@gmail.com -----------------What is Determination Model? What is difference between page break and section report? What is main advantage datawarehousing over oracle? New coloums are added in database, then how you know in report level ----------------Describe DWH Architecture? Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps? Can you explain dynamic query mode?