what is the monster dimension plz give me one example
Answers were Sorted based on User's Feedback
Answer / pooja
Monster dimensions require special handling and advanced
planning, especially when you’re dealing with rapidly
changing monster dimensions. Rapidly changing dimensions
(i.e., dimensions whose content changes as a result of
input errors or changes over time that you’re recording in
place) aren’t too much of a challenge when the dimensions
are small. However, monster dimensions consume large
amounts of maintenance time and CPU cycles because of their
size, so you need to plan carefully when you’re dealing
with them. Let’s explore two different methods for managing
rapidly changing monster dimensions: first, splitting the
dimension, and second, creating a set of non-overlapping
value ranges for each rapidly changing attribute and then
creating rows that include all possible range combinations.
| Is This Answer Correct ? | 7 Yes | 2 No |
Answer / hardeep
Hi Pooja
Thanks for reply but could u pls explain more what type of dimensions are called as monster dimensions... Properties of Monster Dimensions.
Hardeep
| Is This Answer Correct ? | 0 Yes | 1 No |
what is left outer join?
Useful UNIX commands regular/frequently used
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
what is the need of session partitioning... how it is useful in real time
Define pmcmd command?
What is partioning?how many types of partinings are there
Three date formats are there . How to change these three into One format without using expression transformation ?
which one is better performance wise joiner or look up
How can we use batches?
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com