Answer / thammera

This confirm dimenstion methodology.If a dimension table is
connected to more then one Fact table is called confirm
dimension.

Answer / raj

Fact Tables are connected by confirmed dimensions, Fact
tables cannot be connected directly, so means of dimension
we can connect

Answer / dinesh

Two fact tables can connect thru constellation schema. It
is different from Star and snowflake schemas. In
constellation schema , we can join to fact tables
surrounded by dimensions.

Answer / itesh

Yes it’s possible,

Since after all its a table, if you have the proper
relationship no problem,

Conceptually it’s correct to have a have confirmed
dimension but it can be manipulated,

Ex.

I have one fact a table FACT EOD this year i have joined
with EOD FACT Last year with time id .its working fine

Again
If you have two fact table A and B then create a derived
table from B Of the required key and measure only and join
with original fact table A ,

Better check with a sql query.


Nothing is impossible……

Cheers
I

Answer / mallika

We can connect two fact tables by using constellation
schema or galaxy schema.
we have 3 types of schemas

star
snowflake
constellation or galaxy

in star schema we have data redundancy.we do not normalize
dimension tables.
in snowflake we normalize dimension tables to reduce space
boyh star aand snowflake we use only one fact and many
dimesion tables.in some situations we have to use more than
one fact table then we use constellation.but its vary
rarely used

Answer / 9885657928

Ya it is possible to connect the two fact tables By using
Schemas.
Eg:Hybrid schema or Gelaxy schema

Answer / vams_gk

---------------------------------------------------

confrimed
[sales fact]<.........>[customer fact ]
| |
dimentions x,y,z dimentions a,b,c
-----------------------------------------------------

when u applied join between two fact tables u will get a
confriemd dimention

Answer / nethaji

Yes,We can connect two fact tables by using confirmed
dimension indirectly or directly by confirmed fact.Here when
a fact appears in more than one fact table we can join using
this fact.
eg:
fact table 1 fact table 2
------------ ------------
measures maesures
revenue <=======> revenue

What is loop in data warehousing?

0 Answers  

Where the applications and where

0 Answers  

Hi Guys, I have been to L& T last week ..Please find the questions mentioned below 1)Slowly changing dimension types 2)DML statement 3)DDL statement 4)write a syntax to create database 5) differences between count(*) and count(column) 6) differences between union and union all 7) what is decode 8) what is NVL 9) Arrange the values in ascending order 10,5,20,15,null 10)Primary and surrogate key 11)what is group by clause does? 12)what is difference between truncate and delete 13)what is difference between OLAP and OLTP ? 14)Architecture of Datawarehouse 15)how do you test the data validation from source as (flat file and xml) to staging tables. 16)what is shedule and time bound the mentioned above question asked in two rounds.all the best

2 Answers   L&T,

what are the all possible features supported modify stage?

0 Answers  

Can you explain how analysis service works?

1 Answers  

How to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible?

0 Answers  

Which is the optimized method of extracting the data.

3 Answers  

suppose data are coming from different locations and those data will not change . is there any need to use surrogate key ?

3 Answers   Oracle,

What is aggregate awareness?

2 Answers  

How can we load the time dimension?

0 Answers  

What is the difference between static cache and dynamic cache?

0 Answers  

Ist the schema that a data warehouse system can implements.

0 Answers