Interested to Buy Any Domain ? << Click Here >> for more details...
what is confirm dimension ?
- 11 Answers
- 36591 Views
- IBM, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kshatri
Conformed Dimensions (CD): These dimensions are something
that is built once in your model and can be reused multiple
times with different fact tables.
For example, consider a model containing multiple fact
tables, representing different data marts. Now look for a
dimension that is common to these facts tables. In this
example, let us consider that the product dimension is
common and hence can be reused by creating short cuts and
joining the different fact tables. Some of the examples are
time dimension, customer dimensions, product dimension.
| Is This Answer Correct ? | 26 Yes | 5 No |
Answer / balaji
In the schema which dimension shared by multiple fact table
that dimension is called confirmed dimension.
| Is This Answer Correct ? | 12 Yes | 1 No |
Answer / sivakumar.v
Confirm dimension;
Confirm Dimension which is used to link more then 0ne fact
table or data mart.
For ex;
In our project, we have created five data mart of different
subject area ,our client requirements is to create a report
by linking all the data mart or subject area .To achieve
that report we linked all the data mart through Person
confirmed dimension .
| Is This Answer Correct ? | 9 Yes | 3 No |
Answer / chary
Confirm dimension is a dimension which is connected with
more than one fact table.We can say date dimension is the
confirm dimension.
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / naveen
Confirmed Dimension, it is a dimension linked with two fact
tables.
| Is This Answer Correct ? | 6 Yes | 2 No |
Answer / handy
A confirmed Dimension (CD) is a dimension which is shared by
different fact tables.
For examples, there are different data marts are there say
Loans, Deposits, Withdrawals etc.....in this there is a
dimension called Date which is common to all. We can link to
different datamarts using a common dimension called Date in
this example.
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / kvchowdary
A dimension that carries the same meaning across the
different fact tables is called conformed dimension
conformed dimension are a must to put a no of datamarts
together to create a enterprise datawarehouse
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rajesh
Confirmed Dim means a dimensions which is connected with
the two fact tables
suppose we have two fact tables like sales and production
link with dimension product dimension here Product is the
confirmed dimesion
| Is This Answer Correct ? | 2 Yes | 3 No |
Answer / vijaya
It is a time dimension,A dimension table connected with all
the fact tables.
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / ratna
if aprimary key act as a fk in more then fact tablethen it
is known as cd
| Is This Answer Correct ? | 1 Yes | 6 No |
Give some information on report bursting?
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
you have two tables table 1 contains emp id,name and deptno and tble 2 contains only depatment number some of the depatment no of 1st table are not present in table 2 how will you create a report only to get the departments of which excess in table 1
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
when to go for alias and when to go for contexts
I HAVE MONTHS AS DEC,JEN,MAY,APRIL... WHICH PROMPT IS USED TO GET REPORT IN SEQUENCE?
What are @FUNCTION?
how we send repotrts/documents to end user
how many reports have u created ? explain a few.
0 Answers Bank Of America, TCS,
can we cretae views in universe level?
How to link two different universes ?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Teradata 
