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,

---

why we use materialized view over view?

1 Answers   Zensar,

---

What is the way to execute pl/sql script using informatica mapping?

0 Answers  

---

Can any one give me an example for factless fact table ? If your answer is studunt attendence registration,could you plese give me explanation for this ?

3 Answers   Cap Gemini, Puma, Wipro,

---

How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,

---

Parameter and variable differences

0 Answers  

---

Define joiner transformation?

0 Answers  

---

What is a test load?

1 Answers  

---

Can we use Lookup instead of Joiner to join 2 tables? If yes which is faster and why?

2 Answers   TCS,

---

What is tracing level and what are the types of tracing level?

2 Answers   TCS,

---

How many joins in Informatica

5 Answers   CSC,

---

Differentiate between source qualifier and filter transformation?

0 Answers  

---