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 / 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 |
Post New Answer View All Answers
What do you mean by Drill down and Drill Up?
What are the different uses of a repository manager?
Can you define a query subject?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
--------------Diff b/w ODS and OLAP?
Can you define cube?
hi friends pls forward impropmtu interview question
Can you define snapshot?
What is a Query Subject?
What are query items?
Can you explain model durability?
how to perform single sign in cognos by using url?
How we check the errors before running the report?
What are the different types of reports present in cognos?
What you mean by drill across?