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

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

Question Posted / vmvkreddy

3 Answers
23045 Views
CTD, Wipro, I also Faced
E-Mail Answers

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 are the errors faced while bursting the reports and how to solve those errors?

0 Answers EDS,

what is dash board?

2 Answers Syntel,

1.how do nyou configure link between fwm and database (source).if you created fwm where it will be? and if you create reports where it is stored? 2.what is spic shot in fwm?

1 Answers CTS,

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

0 Answers

how you provide security to reports? How you provide security to packages ?

0 Answers IBM,

1.How will u link a list to crosstab.?i.e link a pramater in list so that it shows further information in cross tab.? 2.I have different regions,I want region specific logo to be displayed when I run the report.How it is done ? 3.Among Drill through and Master detail relationship which is more effective? 4.How do u hide a column in list report? Ans: In properties,Burn list option-check whichever column u wanna hide. 5.What is Roll play dimension? 6.What is Data Item Value n Parameter value?,What exactly it ll take when select either of them? 7.How many types of filters are there? 8.What will happen if u use detailed filter ?,n what is da result when used on summary filter?

0 Answers TCS,

What is the difference between Standard and Metrics folder?

0 Answers

what is your project workflow and your role in the project?

5 Answers Syntel,

How applying "Level Span" in Cognos 8.3?

1 Answers

Please explain the different stages in creating a report in cognos report net?

0 Answers

wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container

0 Answers

How many reports did you create in your project?

3 Answers IBM,

For more Cognos Interview Questions Click Here