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
Can you define bitmap index?
What is the enterprise class platform architecture of cognos 8?
How the Bursting happens in same report and how to Print the bursting Report?
How can I schedule reports in cognos?
Why need staging area database for dwh?
what is the difference between native sql and cognos sql?
What is meant by drill down?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
What is difference between content store and content manager?
----------------------What are the User Securities?
what is power prompt in cognos ep7series?what is the use of this?
What is the difference between a data mart and a data warehouse?
What is called materialized view?
How do you Parametermap variables in Quiries?