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

Suppose we have a csv file with contents as below which is
used has a source file.

C1,C2,C3,C4
100,200,A B,300
200,400,X,Y,299 ---> it should be 4 values but by mistake
300,600,C D,566 with a comma in between X & Y,its 5.

My target takes only 4 columns, How to take care of the 2
record as above without rejecting it and loading in the target.

Hope u guys have understood my scenerio

Question Posted / dj

Answer Posted / dj

ou can do this by executing a pre session unix command. Replace consecutive delimiters with some Junk value and later in informatica mapping replace it with null.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the new features of Power Center 5.0?

1698

Can we change Dynamic to Static or Persistent cache? If so what happens?

2146

Explain what are the different versions of informatica?

1031

How identifying bottlenecks in various components of informatica and resolving them?

1054

I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1714

How can we use batches?

960

Difference between Data and Index Caches?

1090

Hi Everybody, I have one fixed width file as source and 4 oracle tables (relational) as target. What are the Unit test cases i need to implement ? 1.Using TextPad software i tested postion of the field 2.As per specification i tested like whether it is correctly mapped or not? Is there any other test case do i need to implement. If possible can any one give me the test cases Advance Thanks

1894

COM components can be used in Informatica

2312

Why union transformation is an active transformation?

992

What is a rank transform?

1024

Have you worked with/created Parameter file

1610

i have a data in my source as a flat files what test i have to perform the next step can any body help to me

2056

Can we create multiple integration service on single repository?

1132

How do you convert single row from source into three rows into target?

1090