Interested to Buy Any Domain ? << Click Here >> for more details...
what is confirmed dimension?
- 6 Answers
- 13482 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri ram
Conformed dimension is a dimension which is connected to or
shared by more than one fact table.
Eg:A business which takes care of both sales and orders of
products then product dimension becomes a conformed
dimension for both sales fact and order fact
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / rr
A dimension that will remains unchanged in entire
datawarehouse. It can be used across all the fact tables.
| Is This Answer Correct ? | 8 Yes | 2 No |
Answer / suresh godugu
A dimension that carries the same meaning across the
different fact tables in called conformed dimension
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / mohini
the dimention table is connect to fact table.the splitted dimention tables are also connect the fact tables.the spiltted dimention tables also carries the same meaning across the total transaction.the dimention tables contains denormalized data.ths z called confirmed dimension.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jayachandra
A dimenssion which is shared by multiple fact tables is
known as "Confirmed dimenssion".
ex:customer dimenssion
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / lokii
A dimension which connects a fact table and a factless fact
table.
| Is This Answer Correct ? | 1 Yes | 7 No |
What are the tasks that can be performed using sq?
111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?
What is the difference between a router and a filter transformation?
Enterprise data warehouse your projects phase by phase explain?
How we will implement Pushdown Optimization and Types in Informatica with better examples
How can we get multiple output values using an unconnected lookup transformation?
version controlling in informatica?
What is the method of loading 5 flat files of having same structure to a single target and which transformations I can use?
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
can u apply SCD2 on flat file tgt? if yes wat is the procedure?
what is the diff b/w target load plan and cbl?
Please let me know how we can implement the below scenario. In a single mapping,more than 500 sources (legacy,VSAM,relational) will be loading into only one target. Whenever I retreive the data(any record) from target, i need to find the details that the record belongs to which source. Thanks in advance..
Teradata 
