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.

Input flatfile1 has 5 columns, faltfile2 has 3 columns(no common column) output should contain merged data(8 columns) Please let me know how to achieve ??

3 Answers   IBM,

---

Can anyone tell me the new features in Informatica 9 Version?

2 Answers   Syntel,

---

What is informatica powercenter repository?

0 Answers  

---

How to delete duplicate records if we have huge volume of records in a table ? (rowid is not the correct approach)

6 Answers   Puma,

---

What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,

---

Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?

2 Answers  

---

How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?

0 Answers   HP,

---

How can one know that a table has indexes and is partitioned? How data will be pulled from Partitions in Oracle for Informatica?

1 Answers  

---

What is router transformation

4 Answers   CSC,

---

Why filter transformation is an active one?

0 Answers  

---

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

---

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

---