Interested to Buy Any Domain ? << Click Here >> for more details...
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?
- 7 Answers
- 26521 Views
- Blue Cross Blue Shield Association, TCS, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Define the cognos reporting tool?
Define metrics studio?
hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com
Define query items?
What is the report studio?
how to create cubes in transformer ?
What is defined as Query studio?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is difference between data mart and data warehouse?
What are the themes in a data warehouse?
Why are meta service important then other services?
What is zero-foot print?
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
how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?
what is the difference between list report and crosstab report?
