Interested to Buy Any Domain ? << Click Here >> for more details...
What is confirmed dimension and fact?
- 7 Answers
- 19340 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 |
What is rank transformation in informatica
what is surrogate id ?
Briefly define reusable transformation?
Can we use different lookup tranformations for a same lookup table (lookup condition may or may not be same)with different output ports? How the cache files will be affected? Please clarify..
What is exact use of 'Online' and 'Offline' server connect Options while defining Work flow in Work flow ?
can any one explain me about junk dimension
i have to extract data from a flat file.the flat file has 10 records.i have to extract the 1st and 5th record every time.how is it done.
What is a grid in Informatica?
Diffrence between static and dynamic cache
Explain pushdown optimization and types in informatica
What are the differences between oltp and olap?
who to split dimentions into sub dimention
Teradata 
