Answer Posted / aparna

A junk dimension is a convenient grouping of flags and
indicators. It's helpful, but not absolutely
required, if there's a positive correlation among the
values. The benefits of a junk dimension
include: ? Provide a recognizable, user-intuitive location
for related codes, indicators and their
descriptors in a dimensional framework.
? Clean up a cluttered design that already has too many
dimensions. There might be five
or more indicators that could be collapsed into a single 4-
byte integer surrogate key in
the fact table.
? Provide a smaller, quicker point of entry for queries
compared to performance from
constraining directly on these attributes in the fact
table. If your database supports bitmapped
indices, this potential benefit may be irrelevant, although
the others are still
valid.

What is union transformation in informatica?

1188

---

Enlist the various types of transformations.

1118

---

Why is sorter an active transformation?

1191

---

What is the difference between informatica 7.0 and 8.0?

1048

---

Please let me know how to make encryption and decryption with example?

1940

---

What is meant by lookup transformation?

1176

---

In which transformation you cannot drag ports into it?

1373

---

What is the Process to creating lookup transformation in informatica

1083

---

Target increases every day even though no new record was inserted

1621

---

Please let me know how to make Data masking in informatica..

1769

---

How do we call shell scripts from informatica?

1186

---

What is transformation?

1153

---

What are the static cache and dynamic cache in informatica?

1241

---

What are the different clients of powercenter?

1112

---

How to update source definition?

1137

---