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
Explain lookup transformation is active in informatica
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Explain dynamic target flat file name generation in informatica
How to generate sequence numbers using expression transformation?
Explain about cumulative Sum or moving sum?
What is the fact table?
Explain the difference between mapping parameter and mapping variable?
What is an active transformation?
Which are the different editions of informatica powercenter that are available?
What will be the approach?
Parameter and variable differences
What is the surrogate key?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
How to go to the older version for a mapping?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?