Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

what are the different types of transformation available in informatica and what are the mostly used ?

3 Answers   TCS,

Do you find any difficulty while working with flat files as source and target?

0 Answers  

HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  

what is informatica metadata?

0 Answers  

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

0 Answers  

how to read data from website into informatica? plsss send answers ASAP thanks in advance.

1 Answers   DELL,

What is rank transformation in informatica

0 Answers   Informatica,

Why sorter is an active transformation?

0 Answers   Informatica,

what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,

explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

0 Answers   TCS, Wipro,

in oracle write query yourname+1 from dual

5 Answers  

Hi Every One When i Start the Workflow, Table is Going to be Stored in the target database But the columns are not going to the target database table in my PC , please give me the solution and waiting for solution

2 Answers  

For more Informatica Interview Questions Click Here
Categories