Interested to Buy Any Domain ? << Click Here >> for more details...
Report studio has two SQL tabs one native SQL and another
one cognos SQL which one is get more preference? which one
we need to consider?
- 7 Answers
- 26832 Views
- Blue Cross Blue Shield Association, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / thakkalapelly anil
cognos sql is most prefarable because it can fetch the data
from multiple databases.
| Is This Answer Correct ? | 12 Yes | 0 No |
Answer / akhilesh pyasi
Cognos SQL because it improved performance of query by
converting simple sql to optimum Cognos Sql.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / krishna tammana
Cognos SQL and Native SQL are two different types of SQL
generated by cognos tool. Native SQL is sub set or same as
Cognos SQL.
Native SQL contains only the functionality that got
executed at database end, apart from this Cognos SQL will
have the Locally processed logic as well.
| Is This Answer Correct ? | 4 Yes | 1 No |
(1)The FWM uses cognos SQL as a default SQL to create and
edit query subjects.
(2)cognos sql supports SQL 99 standards, which are used in
modifying the query subjects.
Where as
(1) The native SQL is the SQL the database uses such as
oracle,sql secver etc.
(2) A cognos query definition engine (QDE) convert the
cognos SQL into a native SOL which will be submitted to the
data source to query the data.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / sridhar
It depends upon the requirement of Report as well database .
If report wants to show from the different database cognos
sql is most prefarable because it can fetch
from multiple databases.
also for calculation as well other complicated business
rules Cognos sql its preferred.
also we can hide the underline tables as well database
source.
Advantage of native SQL will be no need of metadata .
We are passing the Query to native to handle it.
In my experince column name was case senstive if it changes
it was throwing error - isnt wiered :-(.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / venu
cognos sql bcz cognos sql only adheres sql99 rules and work
with multiple datasources and query performance much
fasterthan native sql if we are using data from single
datasource native sql is preferable
| Is This Answer Correct ? | 1 Yes | 1 No |
what are ERP systems?
Is it possible to join multiple Databases in a Catalog?
What is the difference between Standard and Metrics folder?
What is Index?
What is the report studio?
How do you schedule process automatically in cognos.I.e we have 50 reports and 100 users that will schedule daily, weekly, and monthly basis? Pls, give the answers the query early on.
what is stitch query in reportnet?
what is the use of layout component reference
what is logs in cognos
WHAT ARE THE DISTNICT VARIABLES?
Hi everyone, In my report i have ten pages like page1,page2, upto page10, i have textbox prompt when i enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer.
How to create a dynamic column name in Cognos?
6 Answers Aditya Birla, Polaris,
Teradata 
