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

If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  

What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

1 Answers   Qwest,

I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com

119 Answers   Accenture, Gcs, TCS,

Some flat files are there, out of these having some duplicate. How do you eliminate duplicate files while loading into targets?

0 Answers   IBM,

I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)

0 Answers   Saama Tech,

if we have a delimiters at unwanted places in a flat file how can we over come those.

0 Answers  

Is informatica power center designer has 64 bit support?

1 Answers  

I have been working in Informix-4gl for the past 2 years in an MNC company.But I'm interested to work in Business Intelligence tools. Is it possible to change the technology now? I'm really confused, please help me

1 Answers  

How the facts will be loaded? explain

2 Answers   HCL,

Discuss the advantages & Disadvantages of star & snowflake schema?

5 Answers  

Two different admin users created for repository are ______ and_______

1 Answers  

Is it possible to use a client with different version than that of its Informatica server?

0 Answers  

For more Informatica Interview Questions Click Here
Categories