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 |
My source data like... Empid Name 10 chandra 10 sekhar I am expecting result is Empid Ename 10 Chandrasekhar How can we solve this prob?
1:when we develop a project what are the performance issue will raise?? KPIT 2:if a table have INDEX and CONSTRAINT why it raise the performance issue bcoz when we drop the index and disable the constraint it performed better??KPIT 3:what are unix commands frequently used in informatica??
What is the main data object present inbetween source and target. I answered Mapping. Transformation etc.. But it is not the answer. So please give me an apt answer. Thanks in advance
hi all, can anyone please tell me the difference between erwin tool and informatica ?how these both works ? how this both are going to connect with business objects. THANKS IN ADVANCE
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
what is the max/min size allocated for caches.whether index or datacache in any of the transformations like Joiner or Aggregator.bcoz it is set to Auto by default which means we need not to allocate no of bytes or MB.so what is the use of these properties.please let me know about the caches. Thnaks in advance Sai Ram
Explain the scenario which compels informatica server to reject files?
What is difference between partioning of relatonal target and partitioning of file targets?
how will you get 21 to 30 record from 50 records?
Differnce between filter and router?
What is informatica metadata and where is it stored?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?