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
- 24718 Views
- Blue Cross Blue Shield Association, TCS, I also Faced
- E-Mail Answers
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
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
What is the difference between regular dimension and derminant?
How do we convert from Numeric to be Words?
what is requery in cognos?
Can you define slice?
What is a Datastore in Cognos?
What is the difference between set functions and filter function in dimensional data?
What are the types of studio present in Cognos?
What is the function of model design accelerator?
what is model and say about process how to create model and how to test model?
What are the services provided in cognos 8?
Can you define a datastore in cognos?
what r the reports u faced critical and how it can be solved .. any once can u give a best ans for interviw
What is difference between data mart and data warehouse?
hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.
