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 architectue of Cognos 8
How we check the errors before running the report?
What do you understand by the term 'dynamic cube'?
Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance
What is content Manager?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
What is portal page?
-------------Diff b/w Union and Unionall?
Why do we create shortcuts in framework manager
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
How many fact tables you have in your project?
How can we do the unit testing?