Answer Posted / jaimeen shah

You can configure the Update Strategy transformation to
either pass rejected rows to the next
transformation or drop them based on the update strategy
expression. By default, the PowerCenter Server forwards
rejected rows to the next transformation. The PowerCenter
Server flags the rows for reject and writes them to
the session reject file. If you do not select Forward
Rejected Rows, the PowerCenter Server
drops rejected rows and writes them to the session log file.

what is diff b/t sorter t/r and agg have the option sorter property...

1737

---

What is the use of transformation?

569

---

Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?

772

---

Design a mapping to load the cumulative sum of salaries of employees into target table?

889

---

Whats the difference between informatica powercenter server, repositoryserver and repository?

667

---

---

Differences between connected and unconnected lookup?

603

---

Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?

624

---

I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1204

---

What can we do to improve the performance of informatica aggregator transformation?

611

---

Which version configuration tool used in ur project?

2762

---

How can we use mapping variables in informatica? Where do we use them?

616

---

Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.

776

---

What is aggregator transformation in informatica?

539

---

Explain joiner transformation in informatica

664

---

What are the new features of informatica 9.x in developer level?

552

---