Answer / 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.

Answer / kondareddy

for example take one condition in update strategy
source we have 20 records. in  that records we have 4 records has less then 500 salary
 in update strategy condition is

iif(sal<500,3,sal) based on that condition only 15 records stored into target. so it will be effected on rows. becoz in update strategy 3 indicates rejected records....

so it is active....

3. Suppose Seq Gen is supplying a increamental value to a column of a table, suppose, table's column value reaches to maximum value, then what will happen, will the session fail? If it is the situation, then what should be done so that we can stop this kind of situation in advance?

7 Answers   Accenture,

---

How to Join Tables my Source is having 15 table target is one?

4 Answers   TCS,

---

Label in Informatica. How to remove existing Label.

1 Answers   IBM, Infosys,

---

What is router transformation

4 Answers   CSC,

---

Explain sessions and how many types of sessions are there?

0 Answers  

---

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers  

---

waht is dataware house

2 Answers  

---

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

0 Answers  

---

explan ur project architecture?

0 Answers   TCS,

---

What is lookup transformation?

0 Answers  

---

what is the process of target load planing?

2 Answers   IBM,

---

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers   HP,

---