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

Answers were Sorted based on User's Feedback



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

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

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

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

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

Answer / mounika

Cognos SQl:It improves the query subject performance .This
SQL works on any supported database.

Native SQL:It optimized the performacne and this SQL is
used for soecific database

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More Cognos Interview Questions

What will happen if scheduling a report with a prompt page?

1 Answers   Ness Technologies,


How to publish a package by running Java Script?

0 Answers  


How Metrics Studio is better than Report Studio?

0 Answers  


How can we convert imr report into Impromptu web report?

3 Answers  


Is it possible to create drill through access to other report from PDF report?

1 Answers   IBM,


Define datastores in cognos?

0 Answers  


What is Normalization?

3 Answers  


can you tell me what are the dimension tables are used in project

0 Answers   GalaxE,


What are the two types of framework manager?

0 Answers  


What is the report studio?

0 Answers  


What is dtm?

0 Answers  


Give the advantages of cognos?

0 Answers  


Categories