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?

1030

---

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?

1248

---

What are the uses of etl tools?

1128

---

What are pre and post-session shell commands?

1311

---

How does the aggregator transformation handle null values?

1149

---

What are the performance considerations when working with aggregator transformation?

1152

---

When do you use sql override in a lookup transformation?

1099

---

How does a sorter cache works?

1071

---

State the differences between sql override and lookup override?

1209

---

Name the different lookup cache(s)?

1235

---

How many input parameters can exist in an unconnected lookup?

1546

---

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

1041

---