Interested to Buy Any Domain ? << Click Here >> for more details...
What is confirmed dimension and fact?
- 7 Answers
- 19327 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasad.nallapati
A dimension which links with more than one fact table is
called as Confirmed dimesion.
| Is This Answer Correct ? | 13 Yes | 3 No |
Answer / praveen kumar pendekanti
If a dimension exists in more than one fact table is known
as confirmed dimension. For every fact table confirmed
dimension should be there ex:: Time dimension....
| Is This Answer Correct ? | 8 Yes | 4 No |
Answer / yes
It's actually a "conformed" dimension...meaning a dimension that has the same "form" over multiple data marts....
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / bebo
a confirmed dimension is a dimension which is used in more
then one datamart...exp time dim or customer dim
| Is This Answer Correct ? | 2 Yes | 2 No |
Answer / suresh
Conformed dimensions are either identical or strict mathematical subsets of the most granular, detailed dimension. Dimension tables are not conformed if the attributes are labeled differently or contain different values. Conformed dimensions come in several different flavors. At the most basic level, conformed dimensions mean exactly the same thing with every possible fact table to which they are joined. The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rukmini
The dimensions are created once but reuse in multiple times
| Is This Answer Correct ? | 1 Yes | 2 No |
Answer / rekha
A DIMENSION WHICH IS FIXED AND REUSABLE IS CALLED CONFIRMED
DIMENSION
EX : TIME
| Is This Answer Correct ? | 7 Yes | 10 No |
How you know when to use a static cache and dynamic cache in lookup transformation?
What is the difference between Power Centre and Power Mart?
What are the Differences between connected and unconnected lookup?
What are the different ways to implement parallel processing in informatica?
My i/p is 1,2,3,4,5,6,7,8,9,10……….. o/p to be populate in two tables as below. o/p1: 10,20,30,40,50,60,70,80,90……. o/p2: 11,21,31,41,51,61,71,881,91…….
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
How many mapplets u have created? and what is the logic used
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
i have f;latfile source. i have two targets t1,t2. i want to load the odd no.of records into t1 and even no.of recordds into t2.
How to Join Tables my Source is having 15 table target is one?
What all join we can perform in LOOKUP transformation?
Teradata 
