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?
Answer Posted / 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 |
Post New Answer View All Answers
What is cognos connection?
how you create security to reports?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
What is the difference between Open Connection command ang Open Session Command?
how can you get the errors in job? when loops are araised we get error?
WHAT ARE THE DISTNICT VARIABLES?
What is the difference between ‘macro’ and ‘prompt?
What is cognos reporting tool?
How to create a cube in Transformer? What is the process? Please mention process thank u
What is the size of the cube?
Can you define a catalog and types of catalogs in cognos?
How we check the errors before running the report?
what are the names of the reports that you prepared?
what are the errors faced while bursting the reports and how to solve those errors?
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