Suppose we have a csv file with contents as below which is used has a source file. C1,C2,C3,C4 100,200,A B,300 200,400,X,Y,299 ---> it should be 4 values but by mistake 300,600,C D,566 with a comma in between X & Y,its 5. My target takes only 4 columns, How to take care of the 2 record as above without rejecting it and loading in the target. Hope u guys have understood my scenerio

4 Answers   IBM,

---

How the Informatica Server reads perameter file?

1 Answers  

---

A TABLE CONTAINS SOME NULL VALUES . HOW TO GET (NOT APPLICABLE(NA)) IN PLACE OF THAT NULL VALUE IN TARGET .?

5 Answers   HP,

---

Hi experts, For informatica developer, in real time, normally how much we use sql and plsql?

2 Answers   Infotech,

---

Howmany ways yoU can update a relational source defintion and what are they?

1 Answers  

---

---

What is the maplet?

0 Answers   Informatica,

---

source target --------- -------- name no sal name no sal max_sal r 10 1000 r 10 1000 3000 y 20 3000 y 20 3000 3000

7 Answers   Cap Gemini,

---

How to improve the performance of a session using sorter transformation?

0 Answers   Informatica,

---

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

---

Hi, Can anyone just give me the list of all versions of Informatica ? Advance Thanks

2 Answers   IBM,

---

How do you join more than 3 flat files in informatica?

1 Answers   ITC Infotech,

---

star and snowflake schema?

6 Answers  

---