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.........
- 1 Answers
- 2999 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
What is fact table? Explain the different kinds of facts.
Please let me know how to make Data masking in informatica..
What are the reusable transformations?
Where can we find the throughput option in informatica?
what is the size of u r source(like file or table)?
Explain what are the different versions of informatica?
How to create or import flat file definition in to the warehouse designer?
How to load a Dimension ? and how to load a fact table?
What are the various types of transformation?
What is informatica? Why do we need it?
How to extract sap data using informatica? What is abap? What are idocs?
How do you update the records with or without using update strategy?
What is the advantage of informatica?
What is blocking transformation?
differences between service based and product based?
