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


Please Help Members By Posting Answers For Below Questions

how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process

1710


How identifying bottlenecks in various components of informatica and resolving them?

597


have u done any performance tuning? how u ll do?

1877


Explain pushdown optimization $pushdownconfig parameter - informatica

716


What is a pre-defined event and user-defined event?

591






how to create user defined function (udf) in informatica

799


Explain the different lookup methods used in informatica?

599


What are active transformations.

1199


Mention some types of transformation?

620


How to join three sources using joiner? Explain though mapping flow.

714


What happens to map if we alter the datatypes between source and its corresponding source qualifier?

617


Enlist few areas or real-time situations where informatica is required.

603


Define enterprise data warehousing?

648


What is decode in informatica?

670


can we override a native sql query within informatica? Where do we do it? How do we do it?

612