How can we update a record in the target table without using update strategy?

1207

---

What are the advantages of informatica?

1062

---

Describe the impact of several join conditions and join order in a joiner transformation?

1118

---

What is persistent lookup cache?

1101

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

1312

---

What are the uses of etl tools?

1179

---

What are pre and post-session shell commands?

1393

---

How does the aggregator transformation handle null values?

1197

---

What are the performance considerations when working with aggregator transformation?

1213

---

When do you use sql override in a lookup transformation?

1144

---

How does a sorter cache works?

1110

---

State the differences between sql override and lookup override?

1292

---

Name the different lookup cache(s)?

1297

---

How many input parameters can exist in an unconnected lookup?

1605

---

Suppose we do not group by on any ports of the aggregator what will be the output?

1101

---