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 will restrict values in 0-9 and A-Z and a-z and special character.Only allowed these chars otherwise we will reject the records? what is the function we used to restrict...
What is informatica powercenter repository?
In which scenario did u used Mapping variable?
Source as 1 1 2 2 3 3 How to get target as 1 2 3 and 1 2 3
Why we use stored procedure transformation?
how can i invoke pmcmd in command line prompt
What is the difference between Junk and Confirmed Dimention? where can be used htat one in Informatica?
What are the new features of Power Center 5.0?
disable caching in a lookup transformation?
performance wise which one is better in joiner and lookup transformation
when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?