Answer Posted / suresh
Conformed dimensions are either identical or strict mathematical subsets of the most granular, detailed dimension. Dimension tables are not conformed if the attributes are labeled differently or contain different values. Conformed dimensions come in several different flavors. At the most basic level, conformed dimensions mean exactly the same thing with every possible fact table to which they are joined. The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
What is exclusive and normal mode for repository services?
What is a sorter transformation?
What is the difference between router and filter?
Parameter and variable differences
Is it possible to create multiple domains on a single Informatica server?
Under which circumstances, informatica server creates reject files?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
which one is better performance wise joiner or look up
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is the benefit of partitioning a session?
What is sq transformation?
What are the components of the workflow manager?