Answer Posted / zak

1. We can define a primary key at the informatica level and configure session properties for Treat rows as "Update as Update" and check the Update check box.
2. If we shud not define the primary key at informatica level, then we can use Update override in Target properties. But i m not very sure of this. Kindly let me know

What is primary and backup node?

1172

---

What are the new features of Power Center 5.0?

1846

---

Why filter transformation is an active one?

1032

---

Is it possible to use a client with different version than that of its Informatica server?

1189

---

What is source qualifier transformation in informatica?

1064

---

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5786

---

Write the program through which the records can be updated?

1053

---

can u give example for factless fact table

6778

---

Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?

1164

---

Explain lookup transformation is active in informatica

1147

---

What is exclusive and normal mode for repository services?

1189

---

Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps

2080

---

what is mean by complex business rule ?

2218

---

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

6580

---

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1327

---