what is the monster dimension plz give me one example
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between router and filter?
How many number of sessions can one group in batches?
waht type of interface is used for testing the data in informatica
Does an informatica transformation support only aggregate expressions?
What is a difference between complete, stop and abort?
What is a surrogate key?
list out all the transformations which use cache?
Describe data concatenation?
How do you promote a non-reusable transformation to reusable transformation?
What is decode in static cache?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Differentiate between a repository server and a powerhouse?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
write a query to retrieve the latest records from the table sorted by version(scd)
How to generate sequence numbers using expression transformation?