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.

How to open an older version of an object in the workspace?

1131

---

what is unit testing?tell me proceedure

2168

---

can u any challenge your project?

1974

---

Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

2296

---

What is deployment group?

1132

---

What is repository manager?

933

---

Differentiate between source qualifier and filter transformation?

1510

---

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1445

---

server hot-ws270 is connect to Repository B. What does it mean?

2442

---

What is the difference between source qualifier transformations source filter to filter transformation?

998

---

what is the hint? how to use it to reduce the query processing in program?

7634

---

How to handle decimal places while importing a flatfile into informatica?

1134

---

How to convert multiple rows to single row (multiple columns) in informatica

1319

---

Which development components of informatica have the highest usage?

988

---

list out all the transformations which use cache?

1115

---