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
- 23030 Views
- CTD, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / krishna
cognos sql:It Can be Excuted on any of the database.it can
understand anyDB.
Native Sql:Sql Depends on Ds(oracle,sqlserver)
performancewise cognos sql is best.it means cognos sql
brings only the required columns.
| Is This Answer Correct ? | 10 Yes | 2 No |
How to create a dynamic header in a crosstab report using cognos 8.1 report studio?please suggest me.
hai dis Ashok Sahu I'm searhing on cognos.1 want realtime scenarios with solutions.persons having hands on experience in real time plz help me out.
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
what is the difference between rollup aggregation and aggregation ?
What do you understand by the term 'aggregate advisor?'
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What is the function of cognos dispatcher?
how to solve many -many relations ship in frame work manager?and how to avoid cartigen product in frame work manager?
What do you mean by Drill down and Drill Up?
What is Bitmap Index?
What you mean by drill across?
Teradata 
