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
Can you define cognos impromptu?
----------------Diff b/w Dimensional modeling and Relational modeling?
What is model?
dumps needed ASAP for - C2020-180 Cognos IBM Certification
What is set to be cardinality?
How Metrics Studio is better than Report Studio?
What is the difference between a cascading report and drill through report?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
what are the difficult problem are you involved in cognos report net and 8 and impromptu if any pls share with us
What are the types of folder present in cognos?
How can you link a query to a data container manually in Report Studio?
How do you call a store procedure within a transformation?
What is the function of model design accelerator?
What DB View and Bus View?
What is the difference between regular dimension and derminant?
