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
- 3751 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 are the data movement modes in informatica?
What is primary and backup node?
How can you differentiate between powercenter and power map?
Why can't we connect source qualifier and aggrigator transformation to an expression ? Why they resticted to conncet 2 active trasformations to an passive transformation ?
How do you handle two sessions in Informatica
What is the different lookup cache(s)?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What is xml source qualifier transformation in informatica?
suppose in my source flatfile i have 10000 records in that some of master table records missed table records missed then what will u do
in staging we are merging the data and remove the inconsistants data that type of situation what u will done and type of functions u can use
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How union transformation is used?
What is Session and Batches?
can we override a native sql query within informatica? How do we do it?
How to extract sap data using informatica?
