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
how can you get the errors in job? when loops are araised we get error?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
What DB View and Bus View?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
Write various indexes used in cognos?
Why are meta service important then other services?
What are slice and dice?
How to select multiple values from type-in prompt?
What is defined as Cognos Impromptu?
What do you understand by user class in cognos?
Can you define drill down and drill up?
Write some methods to apply securities in framework manager model?
--------------Explain Table of contents?
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
