what is confirmed dimension?
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 |
Target is zero file and how can you send the email?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
What are the new features of informatica 9.x at the developer level?
Tell me one complex query in oracle ?
What is the difference between warehouse key and surrogate key?
What is a unit Testing?
How to eliminate duplicates in FF and oracle both
How do you take care of security using a repository manager
After dragging the ports of 3 sources sqlserver,oracle,informix to single source qualiofier can we map these ports directly to target and how?
I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.
What is polling?
there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?