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 |
i'm searching on cognos..i want to know real time project explanation..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details for project and interview preparation..pls help me out..my mail-id is al.ramu@yahoo.com hope u will respond as soon as possible..thanks..
how to Explain a complex report at the time of interview ? please post the answer very urgent?
Can we install cognos 8 on windwos xp sp3.......(and i like to use data base as sql server 2000.....is it preferable?)......... pls let meknow... thaks in advance...
Hi Experts, Can a single package be shared by multiple users?
What is Stich Query in Reportnet?
what is meaning by Master detailed relationship ? please explain one example
HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks
fiscal year means what???
What is defined as data mining?
1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question
What is the difference between filter & Condition?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,