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 is architectue of Cognos 8

4 Answers  

How we check the errors before running the report?

0 Answers  

What do you understand by the term 'dynamic cube'?

0 Answers  

Re: hi,dis is Hari.I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out. my mail-id is shankerhari17@yahoo.com, hope u will respond as soon as possible. thank u in advance

0 Answers   Satyam,

What is content Manager?

3 Answers   HCL, Kekran Mekran,

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

0 Answers  

What is portal page?

5 Answers   TCS,

-------------Diff b/w Union and Unionall?

3 Answers   Cap Gemini,

Why do we create shortcuts in framework manager

4 Answers  

how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?

0 Answers  

How many fact tables you have in your project?

1 Answers   HCL,

How can we do the unit testing?

3 Answers   Logica CMG,

For more Cognos Interview Questions Click Here
Categories