3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?
- 3 Answers
- 22110 Views
- CTD, Wipro, I also Faced
- E-Mail Answers
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 |
What will happen if scheduling a report with a prompt page?
How to publish a package by running Java Script?
How Metrics Studio is better than Report Studio?
How can we convert imr report into Impromptu web report?
Is it possible to create drill through access to other report from PDF report?
Define datastores in cognos?
What is Normalization?
can you tell me what are the dimension tables are used in project
What are the two types of framework manager?
What is the report studio?
What is dtm?
Give the advantages of cognos?
Teradata 
