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 |
What is the need of an ETL tool?
what are challenges that you faced in testing? give solution to it?
What is the difference b/w natural key and surrogate key
Target is zero file and how can you send the email?
can anyone explain me about retail domain project in informatica?
Filter transformation in the condition one of the data is NULL would the record be dropped.
What is the difference between Connected and UnConnected Lookup Transformation.Give me one or two examples please?
When you connect to repository for the first time it asks you for user name & password of repository and database both. But subsequent times it asks only repository password. Why?
Why we select the table which has minimum number of records as Master table in joiner?
what is the diff b/w cached and unchaed look ups
Where are the source flat files kept before running the session?
When will you use SQL override in a lookup transformation?