What is confirmed dimension?

Answers were Sorted based on User's Feedback



What is confirmed dimension?..

Answer / seshagiri k

A dimension which can be shared with multiple fact tables

OR

A dimension which can be used by one or more fact tables is
called confirmed dimension

Is This Answer Correct ?    14 Yes 0 No

What is confirmed dimension?..

Answer / murali

in the schema, if any any dimension table has been shared
by more than one fact table, it is called as "confirmed
dimension"

Is This Answer Correct ?    8 Yes 1 No

What is confirmed dimension?..

Answer / sree

In addition to that , it is consistent across the data
marts.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Informatica Interview Questions

Difference between Data and Index Caches?

0 Answers   Informatica,


What is confirmed dimension?

3 Answers  


Hi All can anyone tell me where i will get Informatica training in Mumbai?

3 Answers  


There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  


How will u find weather dimension table is big in size of a fact table?

1 Answers  






suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

3 Answers  


write a query to retrieve the latest records from the table sorted by version(scd)

0 Answers   Informatica,


Can you use the maping parameters or variables created in one maping into any other reusable transformation?

1 Answers  


What is IQD file?

1 Answers  


What is update override?

1 Answers   Accenture,


What is workflow? What are the components of the workflow manager?

0 Answers  


What are the types of error logs available in Informatica?

1 Answers  


Categories