Answer Posted / vishnu_kr

Hi,

i guess the SQL override is used in the source qualifier trf
to implement joins, filter, sorter etc..

but update override is used in the Target table definition.
u use this option to update Targets that have no primary
key (hence u can't use update strategy) coupled
with 'Update as update' property in the session mappings tab
and 'Treat rows as' property set as 'Update' in the session
Properties tab.

What is a sorter transformation?

1055

---

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

993

---

What are the main features of Oracle 8i with context to datawarehouse?

2059

---

What is meant by a domain?

1087

---

How do you update the records with or without using update strategy?

1064

---

What is a node in Informatica?

1008

---

What is flashback table ? Advance thanks

1882

---

What are active and passive transformations?

1033

---

Describe expression transformation?

1052

---

What are the reusable transformations?

1104

---

What is rank transform?

952

---

What are data-driven sessions?

1151

---

What are the conditions needed to improve the performance of informatica aggregator transformation?

1041

---

tell me about your project functionality

2307

---

How to partition the Session?

1052

---