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 |
what is dash board?
What are shortcuts? Where it can be used? What are the advantages?
what is the diffence between render variable & style variable with egs? Plz reply ASAP
Is there any comparison available for Cognos Reportnet Vs Crystal reports?
What is the difference between a cascading report and drill through report?
Can u please describe the different types of traps with eg. Thanks
Can you define metrics designer?
What is the advantage of using shortcuts?
What are the steps involved in migrating CRN enviroment to Cognos 8?
3 Answers BMW, Goyal Group, Mersan,
What are the advantages of cognos?
what is the difference between querystudio in reportnet and cognos8
hi, can some one give the information regarding about the best real time project institutes for IBM cognos at ameerpet in hyd