Answer Posted / manjunath

in update strategy flag 4 means INSERT.


0 Insert
1 Update
2 Delete
3 Reject.
if we give any other value the integration service will
treat any other value as an INSERT.

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

2136

---

Can anyone tell me the new features in Informatica 9 Version?

2103

---

What is a filter transformation and why it is an active one?

960

---

Explain what are the different types of transformation available in informatica.

1117

---

Explain pushdown optimization and types in informatica

1053

---

what are 3 tech challenges/ common issues you face?

2326

---

Performance tuning in UNIX for informatica mappings?

2545

---

What are the restrictions of union transformation?

1015

---

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1896

---

how to load dimension table and fact table. plz tell me the steps.

2080

---

What is a transaction control transformation?

1178

---

hi friends .i designed mapping in windows but i want to run mapping in linux.should i install the server components in linux?

1982

---

Implementation methodology

1694

---

What differs when we choose the sorted input for aggregator transformation?

1004

---

In what scenario we use to improve session performance by pushdown optimization?can any one give example?

6138

---