Answer Posted / shashiall

DWH is DSS(Dicision support system),whereas, OLTP is not
DSS.

which one is better performance wise joiner or look up

1097

---

What is domain in terms of informatica?

1009

---

Difference between Data and Index Caches?

1144

---

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?

1513

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1288

---

Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?

1100

---

Design time, run time. If you don't create parameter what will happen

1837

---

How to load a Dimension ? and how to load a fact table?

1423

---

What are the types of lookup transformation?

1083

---

What is rank transformation?

991

---

explain about unit testing? in real time?

2210

---

In which transformation you cannot drag ports into it?

1322

---

How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1115

---

Why update strategy and union transformations are active? Explain with examples.

1247

---

How are the sources and targets definitions imported in informatica designer?

1111

---