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 are the batches and it’s details?
How will u execute a stored procedute from a reportstudio
Column level security in report
what are the types of facts ? explain them?
2 Answers Business Objects, Informatica, Syntel, Teradata,
where we use page break and page set. with example?
what is stitch query?
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
what are determinants?
4 Answers College School Exams Tests, IBM,
What is catalog and types of catalogs in cagonos and which is better?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What is difference between drill through and drill down?
---------- Purpose of Factless Facttable?