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?
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 is Scopr Relationship?
Can we create a web page where the report directory and the output can be viewed directly across cognos connection?
can we put more measure on cross tab? If so how many? How this affect the aggregation?
how can you set the image in the report
What are the two types of framework manager?
what is query subject
example for generated prompt
Can you define transformer?
What are the different types of reports present in cognos?
what is cube size?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
difference between join and union in reportstudio?