Answer / srini

Using conformed diemsion tables

Answer / shree uday

As per Srini post, Confirmed Dimension is right,
If a dimension table which is shared by more than one fact
table is called Confirmed Dimension.
But its not advicable, Coz, it will take a time and also it
going to be trouble.
The primary condition is both the dimension should equal
For eg,Time dimesion.

Answer / ramana reddy

hi,this is ramana reddy from chennai.i hope that everone is
correct their way but thing is to that ,we can conncect 1 r
more then one fact table by using "aggregate awareness"
concept and this process we use to call "fact constilation".

Answer / bhadra

Any two fact tables are connected via a dimension table only
so to connect 3 fact tables we connect each two of them
using a dimension table in between them
Join the primary key from the fact table to the foriegn key
in dimension table

F1 - D1 - F2 - D2 - F3

F* are the fact tables and D* are dimension tables

Answer / ambareesh

vinod kumar reddy told wrong answer.
using pk and fk we can connect 3 fact tables

Answer / x

Through primary keys and foreign keys

Answer / chitwan

Using Stitch Query Concept.

Answer / moon

Bhadra given currect answer ....................

Answer / ganesh

we can connect two r more fact tables using dimension tables

Answer / prit

if i got u, i would like to know what if i join these 3
tables(nothing but FACT Table) with their keys. Raman, is
COGNOS provides AGGREGATE AWARENESS concept??

what is an sid (surrogate key)?

4 Answers   IBM,

how to improve the report performance?

1 Answers  

what are the joins present in reportnet?which is most widely used?

4 Answers   Covansys, IBM, Satyam,

what are the joins present in reportnet?which is most widely used?

2 Answers   IBM, Satyam,

i thought to keep fake experience..as a fresher i can't enter..bcos there is a large gap after my graduation..4 years..any person who enter with fake exp describe how to attend the interview process..

0 Answers  

2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.

0 Answers   HCL,

what is textsource variable

2 Answers   HCL,

Explain difference between powerplay transformer and power play reports?

0 Answers  

What is the difference between cognos 8.2 and cognos 8.3?

5 Answers  

In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,

How can I schedule reports in cognos?

0 Answers  

how to explain a project to the interviewer on sales project and what r the basics to be prepared to attend a interview

2 Answers   IBM,