Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / santhosh kumar s
When dimension is joined with two fact tables this stitched
Query takes place.
EX: Say table Dim_Product ,fact_retail sales and fact_sales
If we write query for this like dim_product inner join with
fact_retail sales and inner join with fact_sales
Result:We will get wrong data(will get multiplied with one
record with all the records in other table)
To over come this:
Should write two seperate queries and should join them .
Result:Will get required data
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
1. Explain your project.
5. Which type of report you build more, list, crosstab or chart and why?
hi my name is siraj i want to know cognos queriy language
how can you get the errors in job? when loops are araised we get error?
What is main difference mapplets and mapping?
Can you explain cognos planning?
-----------With out using DrillThrough how to do Reports?
What are the two types of framework manager?
What do you mean by drill across?
What is a Cube?
what are the dimensions that you have in your current project?list them?
Why cognos scenario is used?
Hi Buddies...i am lalitha. i am willing to appear for cognos bi-author certification. can anyone of you send me cognos dump. please please help me.
What are shortcuts? Where it can be used? What are the advantages?
