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

What is the surrogate key?

1261

---

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

1628

---

Differentiate between joiner and lookup transformation?

1102

---

How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.

1125

---

Differentiate between sessions and batches?

1018

---

What are active and passive transformations?

1081

---

What are the differences between oltp and olap?

972

---

What are the differences between a connected lookup and unconnected lookup?

1070

---

How do you promote a non-reusable transformation to reusable transformation?

1138

---

lookup transformation with screenshots

4005

---

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

1240

---

What is the difference between STOP and ABORT options in Workflow Monitor?

1257

---

What are data-driven sessions?

1205

---

What is lookup transformation?

1042

---

Write the unconnected lookup syntax and how to return more than one column.

1110

---