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

What r the type of indexes u generally used in informatica?

2 Answers   Keane India Ltd,

---

Can you create a flatfile target

3 Answers   ABC,

---

performance tuning of Informatica

1 Answers  

---

How can you display only hidden files in UNIX

4 Answers   Cognizant, L&T,

---

select count(1) from emp? what is the o/p?

5 Answers   TCS,

---

Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?

0 Answers  

---

What is workflow monitor?

0 Answers  

---

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

---

WHAT IS UPDATE OVERRIDE . DIFFERENCE BETWEEN SQL OVERRIDE AND UPDATE OVERRIDE ?

7 Answers   Target,

---

i having source, router transformation, two targets in my mapping... i given two conditions in router 1)sal >500 2)sal < 5000 --------------- my source is havig two sal records (1)1000 (2)2000 then which target will load first? will both targets are get load or single target only get load...... why?

9 Answers   Cap Gemini,

---

which transformation uses cache?

3 Answers   Keane India Ltd,

---

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

0 Answers  

---