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

If a session fails after loading of 10,000 records in to the target. How can you load the records from 10001 th record when u run the session next time?

4 Answers  


h0w many versions have been developed of onformatica so far?

1 Answers   TCS, TetraSoft,


Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...

3 Answers  


Explain sessions. Explain how batches are used to combine executions?

0 Answers  


Hi, In Router transformation I created two groups . One is Passthrough=> True Second one is CorrectId’s => Invest>50000 Here I have one doubt. Can’t I treat default group as Passthrough group (fist group) . Is there any difference between default group and Passthrough group in this scenario? Let me know if you want more information about this scenario. Advance thanks.

3 Answers   IBM,






WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com

0 Answers   TCS,


what is informatica metadata?

0 Answers  


What are the new features of informatica 9.x developer?

0 Answers  


What is router transformation

4 Answers   CSC,


How big was your fact table

0 Answers  


Q. WE ARE LOADING ORACLE TABLE THE PROCESS RUNS THREE HOURS. THIS TABLE IS BEING USED BY SOME DOWNSTREAM TEAMS SO WHAT WE WANT IS IN BETWEEN RUN IS PROGRESS IF ANYONE IS FETCHING THE DATA FROM THE TABLE THEY SHOULD SEE DATA TILL YESTERDAY TILL THAT. AFTER THAT PROCESS IS COMPLETED ONLY THEN TEAM SHULD BE AVAIBLE TO SEE TODAY DATA UPDATED. WE DONOT WANT TO LOG THE TABLE. NEED APROACH FROM YOUR SIDE.

0 Answers  


How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,


Categories