what is confirmed dimension?

Answers were Sorted based on User's Feedback



what is confirmed dimension?..

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

what is confirmed dimension?..

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

what is confirmed dimension?..

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

what is confirmed dimension?..

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

what is confirmed dimension?..

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

what is confirmed dimension?..

Answer / lokii

A dimension which connects a fact table and a factless fact
table.

Is This Answer Correct ?    1 Yes 7 No

Post New Answer

More Informatica Interview Questions

I have source like this 1:2;3. so i want to load the target as 123

4 Answers   HP,


WE HAVE 10 RECORDS IN SOURCE IN THAT GOOD RECORDS GO TO RELATIONAL TARGET AND BAD RECORDS GO TO TARGET FLAT FILE ? HERE IF ANY BAD RECORDS MEANS ITS LOAD INTO FLAT FILE AND SEND AN EMAIL , IF NO BAD RECORDS MEANS NO NEED TO SEND EMAIL . PLZ HELP ME ...

1 Answers  


What do you mean incremental aggregation?

0 Answers  


Whats the difference between $, $$, $$$

9 Answers  


what is confirmed dimension?

6 Answers  






Explain the aggregator transformation?

0 Answers  


We can achieve better perfomance using sorter before an aggragator. Then what is the significance of 'Sorted Input' check in aggregator ?? Please let me know the difference ??

2 Answers  


How do you update the records with or without using update strategy?

0 Answers  


 Code page compatibly –Where all changes are made to handle the scenario.

1 Answers   DELL,


what is data driven?

1 Answers  


what is surrogate id ?

3 Answers   IBM,


normalizer transformation

3 Answers   CTS,


Categories