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

How you can differentiate between connected lookup and unconnected lookup?

1045

---

What is the difference between informatics 7x and 8x and what is latest version?

1067

---

What is standalone command task?

1305

---

Explain the code page compatibility?

1050

---

How to create a non-reusable instance of reusable transformations?

1097

---

Explain lookup transformation source types in informatica

1079

---

Explain why we use partitioning the session in informatica?

1069

---

Explain sessions. Explain how batches are used to combine executions?

1004

---

What is the difference between stop and abort in informatica

1070

---

How to delete duplicate row using informatica?

1017

---

What is the function of union transformation?

1109

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

1952

---

Scheduling properties,whats the default (sequential)

1943

---

what are the fact table & dimensional table in pharmaceutical and hospotal related products???

2117

---

What are the new features of informatica 9.x developer?

952

---