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
- 3879 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
How to do unit testing in informatica?
What is decode in static cache?
What is the difference between STOP and ABORT options in Workflow Monitor?
Is there any way to read the ms excel datas directly into informatica?
What is a passive transformation?
What do you understand by a term domain?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
How do you use reject loader.
In how many ways we can create ports?
What is enterprise data warehousing?
Mention few advantages of router transformation over filter transformation.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
What is the difference between informatics 7x and 8x and what is latest version?
What is mapping debugger?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
