Answer Posted / naresh

If we want to use multiple times in same mapping you can go
for un-connected lookup and It depends on how much data
your processing.

performance wise unconnected lookup is better because its
like reusable one and it will lookup the values only the
condition meet the criteria.

1. It will return only one value
2. It will act as static cache

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2400

---

How can you increase the performance in joiner transformation?

1193

---

Clarify the utilization of aggregator cache record?

1005

---

What is the difference between a repository server and a powerhouse?

1513

---

What are 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?

1080

---

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

1798

---

How many number of sessions can one group in batches?

1160

---

Whats there in global repository

1696

---

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2050

---

Reusable transformation and shortcut differences

1843

---

How can you generate reports in informatica?

1035

---

How do you set a varible in incremental aggregation

1893

---

How we can create indexes after completing the loan process?

1212

---

What are multi-group transformations?

1108

---

What is primary and backup node?

1136

---