Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / rajeshkumar
A conformed dimension can exist as a single dimension table that relates to multiple fact tables within the same data warehouse, or as identical dimension tables in separate data marts. Date is a common conformed dimension because its attributes (day, week, month, quarter, year, etc.) have the same meaning when joined to any fact table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the types of schemas we have in data warehouse and what are the difference between them?
Describe an informatica powercenter?
What are the transformations that are not supported in mapplet?
Can we change Dynamic to Static or Persistent cache? If so what happens?
Differentiate between joiner and lookup transformation?
What is source qualifier transformation in informatica?
How do you update the records with or without using update strategy?
Explain sessions and how many types of sessions are there?
What are the different lookup cache(s)?
What is the way to execute pl/sql script using informatica mapping?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is the benefit of session partitioning?
How many dimensions are there in informatica?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
