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 guidelines to be followed while using union transformation?
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What are the popular informatica products?
What are multi-group transformations?
What is a joiner transformation?
What is the meaning of decode in informatica?
What is an expression transformation?
What is update strategy transform?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
Explain the pipeline partition with real time example?
What are the settings that you use to configure the joiner transformation?
What are the performance considerations when working with aggregator transformation?
Reusable transformation and shortcut differences
What are the different clients of powercenter?
What is repository manager?