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

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

2 Answers  

---

How informatica recognizes mapping?

2 Answers   CTS,

---

Quickly characterize reusable change?

0 Answers  

---

My source table having some records ,i want load 1st record and last record into one target?

3 Answers   iGate,

---

tell me the informatica architecture

1 Answers   Banca Sella, Wipro,

---

LOOKUP Condition is nothing but a Join condition? What type of join condition it,by default ? Using the LookUP Condition How many types of relational conditions we can make ?

6 Answers  

---

what is dynamic cashe

3 Answers   Informatica,

---

i have a source with 100 records.i have 2 targets.in the first target i want to load first 50 records & in the second target i want to load next 50(or remaining) records.

3 Answers  

---

How we can get unique records into one target table and duplicate records into another target table??

11 Answers   Deloitte, IBM, iGate,

---

Data transformed successfully from Source table to target table. Now how you will ensure that the data in Target table is proper. I answered will verify one or two records and check Then question was that the Development is doing (1-2 record verification)but as a tester you have to verify the complete data, how you will do?? Please answer

2 Answers  

---

how the informatica server sorts the strings values in rank transformations?

3 Answers   TCS,

---

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

---