Interested to Buy Any Domain ? << Click Here >> for more details...
3. Differences between Cognos Sql & Native Sql? What are
their Advantages and Disadvantages?
- 3 Answers
- 23164 Views
- CTD, Wipro, I also Faced
- E-Mail Answers
Answer Posted / vishal
Cognos Sql: This Sql is genreated by cognos on the behaf of
your query. It is good for your own calculation and for the
performance tunning also.
Native Sql: This is Sql based query which has typical
database format and funcatons. All the caculation done at
database only.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is the use of Cognos scenario?
What is difference between primary key and unique key constraints?
What is difference between data mart and data warehouse?
What do you understand by the cognos?
write a query to display the departments with no employee?
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Give me any example of semi and non additive measures?
What is a Cube?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
what is online view?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
i have one file i saved in csv how can i take these file into framework manager
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What are shortcuts? Where it can be used? What are the advantages?
