Answer / bala govi

Either your SQL Override is not reading any records, or
your update stregy is not using the correct condition or
check the task SQL Override and check the properties and
make sure "Enable Test Load" is turned off.

Hope this helps

Bala

Answer / krishnakanth.ch

There could be many possibilites:

1) Data are getting rejected due to primary key violation
2) The conditions given in filter or router or update are
satisfying.
3) Make sure 'Enable Test load' option is not enabled.
4) Check for any post sql override in the session
Properties.

what is shared Cache. when we will use shared Cache?

4 Answers  

---

wt is Dynamic lookup Transformation? when we use?how we use?

2 Answers   TCS,

---

How to start a workflow using pmcmd command?

0 Answers  

---

My source is EmpID, Salary- (101, 1000)(102, 2000)(103, 3000). In the Target I want the following EmpID, Salary, Composite_Salary- (101, 1000, 1000)(102, 2000, 3000)(103, 3000, 6000). Please guide on how to build the mapping.

5 Answers   Amdocs,

---

sorce is a flatfile only 1st and last row should insert to target how will u do?

2 Answers   HCL,

---

How do you change parameter when you move it from development to production.

1 Answers  

---

without using rank transformation how can we rank items by using some other transformations

2 Answers  

---

If source is having 5000 rows,and if you want to load data into 500 rows to target,if the session runs successfully,how can you verify the target if the rows are successfully loaded or not.

3 Answers   IBM, TCS,

---

what is the difference between copy object import objects using repositery manager which one is best

1 Answers   TCS,

---

what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?

0 Answers  

---

write sql query following table amount year quarter 1000 2003 first 2000 2003 second 3000 2003 third 4000 2003 fourth 5000 2004 first 6000 2004 second 7000 2004 third 8000 2004 fourth i want the output year q1_amount q2_amount q3_amount q4_amount 2003 1000 2000 3000 4000 2004 5000 6000 7000 8000

1 Answers   HP,

---

8.what is mapplet ?give example?

2 Answers  

---