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
- 3705 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 diff b/t sorter t/r and agg have the option sorter property...
have u done any performance tuning? how u ll do?
What are connected or unconnected transformations?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
State the limitations where we cannot use joiner in the mapping pipeline?
How can we create index after completion of load process?
What are the types of schemas we have in data warehouse.
What are mapplets? How is it different from a Reusable Transformation?
what is mean by complex business rule ?
explain abt ur project architecture?
What is the difference between informatics 7x and 8x and what is latest version?
What is depict expression change?
Which is the t/r that builts only single cache memory?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
Can we create multiple integration service on single repository?
