Answer Posted / raghav

Following options are available for update strategy :

DD_INSERT : If this is used the Update Strategy flags the row for insertion. Equivalent numeric value of DD_INSERT is 0.
DD_UPDATE : If this is used the Update Strategy flags the row for update. Equivalent numeric value of DD_UPDATE is 1.
DD_DELETE : If this is used the Update Strategy flags the row for deletion. Equivalent numeric value of DD_DELETE is 2.
DD_REJECT : If this is used the Update Strategy flags the row for rejection. Equivalent numeric value of DD_REJECT is 3.

so u can use update strategy for delete, reject or insert.

Explain lookup transformation in informatica

1003

---

What is the use of an aggregator cache file?

1135

---

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?

9967

---

What is the use of code page?

1007

---

While migrating the data from one environment to another environment how would you manage the connections?

1046

---

In informatics server which files are created during the session rums?

1062

---

Explain incremental aggregation in informatica

1063

---

what is size of u r database?

2244

---

Make a note of the quantity vaults made in informatica?

941

---

Explain about cumulative Sum or moving sum?

975

---

What is the difference between informatica 7.0 and 8.0?

951

---

Explain the different lookup methods used in informatica?

972

---

What is domain and gateway node?

1118

---

Name the different lookup cache(s)?

1157

---

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

7311

---