Answer Posted / ratalarayudu

hi,

The main purpose of unconnected lookup t/r is

1.To update slowly changing dimensions
2.if we want to use the same lookup multiple times in a
mapping we can go for unconnected lookup
3.if we want to lookup on only selected rows then we can go
for unconnected look up.

regards,
rayudu.

Explain in detail scd type 2 through mapping.

1002

---

What are the different versions of informatica?

1213

---

What are mapplets? How is it different from a Reusable Transformation?

1049

---

How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

1087

---

Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

966

---

What is dynamic cache?

993

---

What is olap (on-line analytical processing?

1027

---

Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

997

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1075

---

Differentiate between Load Manager and DTM?

2108

---

what is diff b/t sorter t/r and agg have the option sorter property...

2143

---

what is INFORMATICA TESTING process

2250

---

What do mean by local and global repository?

1176

---

How union transformation is used?

971

---

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

1239

---