Interested to Buy Any Domain ? << Click Here >> for more details...
what is confirmed dimension?
- 6 Answers
- 13581 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 |
r u done any partitions in ur project?
what are the limitations of pushdown optimization technique ? Advance thanks
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
differnece between joiner and a look up(please don't give just definitions)....i mean in which scenario it is better to use joiner and in which scenario better o use lookup ??
100 records in source and i have 3 targets, my requirement is first record insert into 1st target,2 record into 2nd target,3 record into 3rd target and again 4th record into 1st target like dat..how to implement dis?
What is workflow? What are the components of the workflow manager?
hw cn v elimate dublicate values from lookup without overriding sql?
In a concurrent batch if a session fails, can you start again from that session
How can you join two tables without any common column present in them?
How do you load only null records into target?
What are the tasks that source qualifier perform?
how can run the wf through pmcmd commend? write script?
Teradata 
