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
whats the difference between previous version of cognos and cognos 8 BI?
What are the components of report net?
how u will determine the performence tune will occur either in report or system
How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?
What are products of cognos?
What are shortcuts? Where it can be used? What are the advantages?
What is the importance of having monitor service in cognos?
what is model and say about process how to create model and how to test model?
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
what is online view?
difference between impromptu and cognos8
what is degenerate key in oracle ?whare do we use it?
what are the names of the reports that you prepared?
how to perform back drill through in cognos 8 what is the use of it
What is Bitmap Index?
