What is confirmed dimension?
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / sree
In addition to that , it is consistent across the data
marts.
Is This Answer Correct ? | 4 Yes | 1 No |
Difference between Data and Index Caches?
What is confirmed dimension?
Hi All can anyone tell me where i will get Informatica training in Mumbai?
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)
How will u find weather dimension table is big in size of a fact table?
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 ?
write a query to retrieve the latest records from the table sorted by version(scd)
Can you use the maping parameters or variables created in one maping into any other reusable transformation?
What is IQD file?
What is update override?
What is workflow? What are the components of the workflow manager?
What are the types of error logs available in Informatica?