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

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers   TCS,

---

wat are deployement groups in informatica, how it will be used for developers

0 Answers  

---

Explain lookup transformation source types in informatica

0 Answers   Informatica,

---

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,

---

What is the Hierarchy of DWH?

1 Answers  

---

Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab

0 Answers  

---

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,

---

Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

0 Answers  

---

What is difference between maplet and reusable transformation?

2 Answers  

---

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  

---

What is a stored procedure transformation?

0 Answers  

---

All active transformations r passive or not?

7 Answers  

---