By using replace char function we can write this Suppose length(re

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

Question Posted / naveen

4 Answers
9232 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / naveen

By using replace char function we can write this

Suppose

length(replacechr(c3,'1234567890abcdefghtijklmnopqrstuvwzyz',null))

Is This Answer Correct ?

0 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Did u used latest transformations of 8.6.0? for what?

1882

What is informatica? Why do we need it?

1101

What is joiner transformation in informatica?

1045

How might one distinguish in the case of mapping is right or not without associating session?

1123

Enlist the tasks for which source qualifier transformation is used.

1040

How to generate sequence numbers?

1089

What are the transformations that are not supported in mapplet?

1032

what is INFORMATICA TESTING process

2294

What is a joiner transformation?

997

differences between service based and product based?

2015

What is a pre-defined event and user-defined event?

1037

Partition, what happens if the specified key range is shorter and longer

2499

What are the types of schemas we have in data warehouse and what are the difference between them?

942

What is a passive transformation?

1105

if we have a delimiters at unwanted places in a flat file how can we over come those.

2049