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 |
Explain incremental aggregation in informatica
I am hvaing SOURCE as first line: 1000,null,null,null second line as:null,2000,null,null 3rd line as :null,null,3000,null and final line as: null,null,null,4000 ............................Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out
WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?
What is Java Transformation? what are the uses of it?
What are the designer tools for creating tranformations?
What are the issues u have faced in ur project? Guys pls answer to dis question.Due to this question I have failed in 3 interviews.
how did u understand business requirement?
Can we insert ,update ,delete in target tables with one update strategy tran.?
what is semi-additive fact?where did u used?
what is the use of Data Mart?
what are challenges that you faced in testing? give solution to it?
What is an unconnected transformation?