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

Are there any types of Dynamic Caches in informatica

4 Answers   Accenture,

What is diff joiner and lookup

4 Answers   BirlaSoft,

What is the format of informatica objects in a repository?

0 Answers  

what is metadata?

8 Answers   Satyam,

Define enterprise data warehousing?

0 Answers  




I want skip first 5 rows to load in to target? what will be the logic at session level ??

1 Answers   IBM,

What are the reusable transforamtions?

1 Answers  

What is the Router transformation?

2 Answers   Informatica,

I have 1200 records how can u send it in aggregator with good performance issues?

3 Answers  

performance wise which one is better in joiner and lookup transformation?why?explain clearly?

4 Answers   IBM,

Implementation methodology

0 Answers  

How Union Transformation is an Active Trans?

6 Answers  

For more Informatica Interview Questions Click Here
Categories