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

How many number of sessions can one group in batches?

0 Answers  

---

What are the modules in Power Center

0 Answers  

---

what is the significance of newlookup port in dynamic look up

1 Answers   IBM,

---

How union transformation is used?

0 Answers  

---

who to split dimentions into sub dimention

3 Answers   Wipro,

---

What is up date strategy and what are the options for update strategy?

2 Answers  

---

what is lookupoverriding?

1 Answers  

---

What is union transformation in informatica?

0 Answers  

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

What is sql query override? When did u use sql query override?

1 Answers   TCS,

---

i have a session which creates a file every time when i runs the session, but it replaces the first file with second file,i want to append the second file follwed by first file when i runs the session,how to achieve this?

1 Answers   Thomson Reuters,

---

How to get EVEN & ODD numbers separately?

8 Answers  

---