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 is domain in terms of informatica?

0 Answers  

---

What are the types of groups in Router transformation?

1 Answers   Informatica,

---

Explain the types of lookup transformation?

0 Answers  

---

what is shared lookup&persistent lookup?

4 Answers   Accenture, Cap Gemini,

---

What is a stored procedure transformation?

0 Answers  

---

---

How to Display top 2 salaries for each department WITHOUT using Rank Transformation And WITHOUT using SQL queries in source qualifier.

3 Answers   Eureka Forbes,

---

What is a command that used to run a batch?

4 Answers  

---

how can one come to know wether the records loak into the target if we use update strategy

1 Answers   Wipro,

---

i have a flat file and the file s are like below ****%%^^@@@G**@#A@#$N*&^E%^S@#h@@@##$$ IN THIS FORMATE Means un limited special charecter between and sides of the string data..output should be(GANESH) HOW YOU HANDEL THIS TYPE OF RECORDS,,COZ U DON"T KNOW WHERE AND WHAT ARE THE SPECIAL CHARACTERS IN BETWWEN THE NAME...

6 Answers   IBM,

---

following table source name gender a1 male a2 female how to change 'male' to 'female' and 'female' to 'male'

2 Answers  

---

What are the advantages of using informatica as an etl tool over teradata?

0 Answers  

---

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

---