Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / bhaskar.nagi
The SQL generated by Cognos 8 known as a stitched query.
Stitch query in cognos to avoid full outer joins. If you are
trying to model a full outer join involving two fact tables
related through a common dimension table, note
that Cognos 8 will handle such situations using a stitch
query, which does not require that you model any of the
relationships as an outer join. As of my understanding, this
is kind of after importing metadata, when we are giving
joins or relationships between the queries, for better
performance and to be not confusing in giving the joins we
will be breaking the query to multiple queries or merging
two queries in to one query. those queries are called
stiched queries.
| Is This Answer Correct ? | 11 Yes | 12 No |
Post New Answer View All Answers
What is the difference between a data mart and a data warehouse?
-----------------What is Direct and Conventional loading?
What is metric store database?
how to explain health care project and which reports we can create in health care doain?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
How do you call a store procedure within a transformation?
Explain the difference between powerplay transformer and power play reports?
New coloums are added in database, then how you know in report level
What is the model filter?
Explain about scorecarding?
Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice
---------------Describe OLAP Reporting and RDBMS Reporting?
5. Which type of report you build more, list, crosstab or chart and why?
Can you explain dynamic query mode?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
