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.

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

write a query following source region sales 1 1000 2 2000 i want the output ?please give solution 1 2 1000 2000

8 Answers   TCS,

---

What are the transformations that cannot be placed between the sort origin and the joiner transformation so that we do not lose the input sort order?

0 Answers  

---

what is the look up transformation?

2 Answers   Informatica,

---

I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  

---

How do you update the records with or without using update strategy?

0 Answers  

---

---

what is difference between dimention table and fact table?

1 Answers  

---

i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this

5 Answers   TCS,

---

What is the difference between Power Centre and Power Mart?

5 Answers   TCS,

---

there is a product table prodid prodname price 100 cinthol 10 101 hamam 10 102 neem 20 103 cake 30 in the above table the price of some products are duplicated and some product prices are distinct we want to push the duplicated prices to one target and non-duplicated prices to other target without using expression and sequence generator transformation

4 Answers  

---

How to extract sap data using informatica? What is abap? What are idocs?

0 Answers  

---

What are the differences between joiner transformation and source qualifier transformation?

0 Answers   Informatica,

---

what are the deliverables?in your project?

0 Answers   DELL,

---