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 |
Make a note of the quantity vaults made in informatica?
How can we reset Sequence Generator, when we move objects from Dev Environment to QA env?
difference between informatica 8.1.1 and 8.6
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
What you know about transaction control transformation?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
How an expression transformation differs from aggregator transformation?
Suppose we do not group by on any ports of the aggregator what will be the output?
suppose i have source 101 a 101 b 101 c 101 d i want target like 101 abcd how will u achive this please give me the answer
What is the Difference between sorter and aggregator?
update strategy transformation in informatica
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?