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 |
How to recover sessions in concurrent batches?
i have a source of n records.i have to load n+5 records to my target.What is the procedure??????plz tell me.....
What does role playing dimension mean?
What is the difference between unicode & ascii mode data movement in informatica?
can u give example for factless fact table
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
comonly how meny mappings r there in Banking projects?
What is a filter transformation and why it is an active one?
what is procedure to use mapping variable in source qualifier transformation? with example
if the session fails after 100 records agian we have to starts the session or we go for recovery session
Data is passed from one active trans and one passive trans into a passive transformation.Is the mapping valid or invalid?
what is a time dimension? give an example?