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
How identifying bottlenecks in various components of informatica and resolving them?
How might one distinguish in the case of mapping is right or not without associating session?
where to store informatica rejected data?
What do mean by local and global repository?
Can we create two repositories on same database instance in oracle?
What is dimensional table?
What is an active transformation?
Can we create multiple integration service on single repository?
How to extract the informatica rejected data?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What is standalone command task?
What is the advantage of informatica?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
Different sorts of metadata that stores in the storage facility?