Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

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

Question Posted / vmvkreddy

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 limitations of cognos reportnet? What are the enhancements in reportnet ?

0 Answers   Cognos, IBM,

what happens when date function has taken as attribute

1 Answers   TCS,

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

0 Answers   TCS,

What is a Transformer?

0 Answers  

A report is scheduled at 2am in the night... and the report contains 4 value prompts how it is going to be executed without selecting the values....if executed who is going to select the values from the value prompt

1 Answers  

cognos reportnet is molap or rolap ... somebady telling cognos reportnet is molap and other will be telling rolap ... i need extract answer

5 Answers  

What is Model Versioning or Versioning in Cognos Framework Manager?

2 Answers   Systime,

Can you define dimension?

0 Answers  

How can we convert imr report into Impromptu web report?

3 Answers  

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

0 Answers  

6. Which of them will increase the performance?

1 Answers  

Hi Techies..., can any one please answer me what is called unit testing ? how to do it and what are the steps involves in it? thanks for your answer......

1 Answers  

For more Cognos Interview Questions Click Here
Categories