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 type of charts we create mostly in realtime? plz help

4 Answers   IBM,


what is physical layer and presentation layer?

2 Answers   Zensar,


can we create master detail report where master and detailed container is separate?

2 Answers   JPMorgan Chase,


Can you define set to be cardinality?

0 Answers  


A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

0 Answers  






After applying date prompt and when we run the report we fet from date and todate prompts..so when we enter todate<fromdate its an error. How can we generate the user defined error message for this type of error

0 Answers   IBM,


how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers   TCS,


what is cardinality that you can give to employee and department query subjects in framework manager?

2 Answers   HCL,


what is an associated query?

2 Answers  


-----------What is member Description?

2 Answers  


What is a Pivot?

0 Answers  


Where do you edit cognos sql in report studio?

3 Answers   HCL,


Categories