EDIT MANUALLY IN FLATFILE. REPLACE IT AS SOMEOTHER CHARACTER. AND PASS IN

Hi experts,
> I 'm having data like this and it's in flat file.
> sno,name,marks,result
> 1, ak, 80,p
> 2, , ,20,f
> 3,jack,55,p
>
> now in the second row a comma(,) is placed instead of
name(char).
>
> when importing into SQ , in flat file wizard the num of
columns increased to 5 instead of 4.
>
> could you tell me how to over come this issue.........

Question Posted / chiky

1 Answers
3662 Views
TCS, I also Faced
E-Mail Answers

Answer Posted / chiky

EDIT MANUALLY IN FLATFILE.
REPLACE IT AS SOMEOTHER CHARACTER.
AND PASS IN MAPPING. iN MAPPING YOU CAN REPLACE.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can we create index after completion of load process?

1071

wf dont have integration severances how you can run?

1883

Differentiate between Load Manager and DTM?

2093

What are active and passive transformations?

1020

5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C

1842

Describe expression transformation?

1044

Clarify the utilization of aggregator cache record?

943

How can you increase the performance in joiner transformation?

1134

What is the difference between source qualifier transformations source filter to filter transformation?

996

Differences between version 7.x and 8.x.

1840

What are the basic requirements to join two sources in a source qualifier transformation using default join?

1031

draw informatica architecture 8.6 ?

3820

I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1942

Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

1267

What is enterprise data warehousing?

987