Interested to Buy Any Domain ? << Click Here >> for more details...
What is confirmed dimension and fact?
- 7 Answers
- 19455 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 are the prerequisite tasks to achieve the session partition?
Hi Friends, How i could convert a cobol file (VSAM) into the flat file? How i could edit a cobol source file (VSAM)? I want to introduce few columns in the source file and finally the target should be in the Cobol itself. Kindly suggest me friends. Thanks in Advance, Innai
What is an Integration service in Informatica?
tell me the push down optimization
In dimension and fact table? which one holds big data?
What is Data Caches size?
Which is the best place to learn Informatica Powercenter Online Training?
What are Target Options on the Servers?
How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)
what is diffrence b/w joner and union transfermation
What is sequence generator transformation in informatica?
What if the source is a flat-file? Then how can we remove the duplicates from flat file source?
Teradata 
