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 |
Does an informatica transformation support only aggregate expressions?
What is the difference between Active and Passive transformation?
in flatfile target how can u create header and footer plese give me the comands how will u write in session properties
if we are extracting 600000 records from a source table so how much volume of records frequently we load in warehouse. (Iknow its depend on client requirement) still i want to know how much volume of records store in warehouse.
difference between repository database and repository service?
How Union Transformation is an Active Trans?
Quickly characterize reusable change?
following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'
Can you generate sequence numbers without using the sequence generator transformation?
Three date formats are there . How to change these three into One format without using expression transformation ?
While using update strategy in the mapping which gives more performance, a flat file or Table? Why? What are the advantages and disadvantages?
What is informatica metadata and where is it stored?