1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.........

Question Posted / kalpana


Hi experts, > I 'm having data like this and it's in flat file. > sno,name,marks,r..

Answer / 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

More Informatica Interview Questions

Partition, what happens if the specified key range is shorter and longer

1 Answers   Cap Gemini,

what is difference between COM & DCOM?

1 Answers   Satyam,

What are the types of lookup caches?

10 Answers   Accenture, IBM, Informatica,

How might you approve all mappings in the archive all the while?

1 Answers  

wht is cdc?how to use it in creation of mappings?

6 Answers   HSBC,

What is difference between Informatica 6.2 Workflow and Informatica Workflow 7.1

4 Answers   IBM,

Can you create a flatfile target

3 Answers   ABC,

Explain the different kinds of facts.

1 Answers  

How many cubes create from a single model?

1 Answers  

Kimball and Inmon methodologies?

2 Answers  

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1 Answers  

in what type of scenario bulk loading and normal loading we use?

2 Answers   Cognizant, Wipro,

For more Informatica Interview Questions Click Here
Categories