Answer Posted / rayudu

Yes By default if we wont use update stratagey t/r it will
insert the record by default .And if we want to update
without using update stratagey give the property UPDATE for
TreatSource rows at session level and in target properties
give updateas Update so that we can update without using UPD
T/r.

Regards,
rayudu.

Mention some types of transformation?

1048

---

If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?

10167

---

How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1581

---

Why update strategy and union transformations are active? Explain with examples.

1240

---

What do mean by local and global repository?

1226

---

What is olap (on-line analytical processing?

1069

---

What is enterprise data warehousing?

1048

---

How an expression transformation differs from aggregator transformation?

1043

---

What is persistent lookup cache?

1029

---

What is informatica? Why do we need it?

1097

---

define galaxy repository in informatica

2228

---

Is it possible to revert a global repository to local one and why?

1081

---

Explain where to store informatica rejected data? How to extract the informatica rejected data?

1012

---

How to start a workflow using pmcmd command?

1250

---

tell me about your project functionality

2341

---