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 |
when will we go for unconnected lookup transformation in Informatica?
What does role playing dimension mean?
i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.
i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need
In joiner, how to load Master table in Target?
Can I create one wrkflw which will run different wrkflws on schedule time?
task is running successfully but data is not loded why?
How can i set break points in debugging mode ? can explain steps please?
How can i catch the Duplicate Rows From SorterTrans in a Seperate Target Table ?
surrogate keys usage in Oracle and Informatica?
5 Answers ITC Infotech, Oracle,
Which is better performance wise database or file?How?
In Joiner Transformation, how to identify the master and detail tables if one is from Oracle and the other is from Sybase.