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 an sid (surrogate key)?

4 Answers   IBM,

what is mean by complex starschema ,star schemagrouping?

0 Answers  

Can any one help me about cubes in cognos.How to create the cubes and how to migrate from development to QA and also what is the procedure to refresh teh cubes.

2 Answers  

Why are meta service important then other services?

0 Answers  

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

0 Answers  

What is the size of database for you project?

0 Answers   Accenture,

What is the function of cognos dispatcher?

0 Answers  

What is Normalization?

3 Answers  

What is the deployment requirements used in cognos?

0 Answers  

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

0 Answers  

How many fact tables and dimension tables in your project?

3 Answers   IBM,

What are differences between Reporter report and Explorer report?

2 Answers  

For more Cognos Interview Questions Click Here
Categories