Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3788 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 the Rank index port in Rank transformation?
Explain about Informatica server process that how it works relates to mapping variables?
Explain constraint based loading in informatica
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
Mention few advantages of router transformation over filter transformation.
On which transformations you created partitions in your project?
Differentiate between joiner and lookup transformation?
What are the types of lookup transformation?
What is meant by lookup transformation?
What if the source is a flat-file?
What is mapping debugger?
What is aggregate cache in aggregator transformation?
What is aggregator transformation in informatica?
What is the scenario which compels informatica server to reject files?
Explain Dataware house architecture .how data flow from intial to end?
