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

1150

---

What are the advantages of informatica?

1014

---

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

1063

---

What is persistent lookup cache?

1035

---

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?

1249

---

What are the uses of etl tools?

1129

---

What are pre and post-session shell commands?

1316

---

How does the aggregator transformation handle null values?

1150

---

What are the performance considerations when working with aggregator transformation?

1155

---

When do you use sql override in a lookup transformation?

1101

---

How does a sorter cache works?

1075

---

State the differences between sql override and lookup override?

1211

---

Name the different lookup cache(s)?

1236

---

How many input parameters can exist in an unconnected lookup?

1547

---

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

1044

---