3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you define confirmed dimension?

808


What are initial page components of Cognos connection?

795


How to deploy from one server to another server?

2205


which type of project we r going to snowflake schema

1753


can we insert all types of charts in a list report? what r the realtime prompts?

1927


What are the themes in a data warehouse?

768


Define metrics studio?

771


what is online view?

1711


What are the types of security?

767


What is difference between page break and section report? What is main advantage datawarehousing over oracle?

796


What are all the different types of prompt in cognos?

726


What is zero-foot print?

776


Can you define pivot?

729


where you can save the report net documentation in our local system?

828


Write various indexes used in cognos?

731