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

1103

---

What are the advantages of informatica?

969

---

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

1023

---

What is persistent lookup cache?

985

---

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?

1215

---

What are the uses of etl tools?

1083

---

What are pre and post-session shell commands?

1256

---

How does the aggregator transformation handle null values?

1106

---

What are the performance considerations when working with aggregator transformation?

1117

---

When do you use sql override in a lookup transformation?

1045

---

How does a sorter cache works?

1023

---

State the differences between sql override and lookup override?

1140

---

Name the different lookup cache(s)?

1173

---

How many input parameters can exist in an unconnected lookup?

1513

---

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

1001

---