3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krishna
cognos sql:It Can be Excuted on any of the database.it can
understand anyDB.
Native Sql:Sql Depends on Ds(oracle,sqlserver)
performancewise cognos sql is best.it means cognos sql
brings only the required columns.
| Is This Answer Correct ? | 10 Yes | 2 No |
diff b/w dimension and regular dimension
Diff b/w Crossproduct and Outerjoin?
Can you define a query subject?
Main Differnce between Cognos7 and Cognos8
After generating value prompt,when we run the report... then we will get the prompt in the output.. Along with that prompt we will get diff types of symbols highlited......How can we hide those symbols?
How to hide the prompts
what are determinants?
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
any difference between cognos and real time cognos
dumps needed ASAP for - C2020-180 Cognos IBM Certification
Give the advantages of cognos?
what is the procedure for scheduling conditional rendering?