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

MY SOURCE IS LIKE THIS VENKATESH,101||RAJESH,102||SIVA,103||SWATHI,104
MY REQUIRMENT IS
NAME ID
VENKATESH 101
RAJESH 102
SIVA 103
SWATHI 104

PLEASE PROVIDE ME THE SOLUTION

Answer Posted / vijaya

two types
treat consecutive delimiters as one in import from flat file
then use a normalizer transformation you will get the answer

second type in unix scripting you can get the o/p

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to update a particular record in target with out running whole workflow?

1629


How to create the source and target database connections in server manager?

1132


What do you mean incremental aggregation?

1131


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1648


waht type of interface is used for testing the data in informatica

2300


What is a repository manager?

1148


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

2174


how to create user defined function (udf) in informatica

1352


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2445


Briefly explain the aggregator transformation?

1068


Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?

1727


Difference between Data and Index Caches?

1207


How many number of sessions can one group in batches?

1215


4 yrs etl devloper roles and responsibilities?any body give solutions

2247


Can you use flat files in Mapplets.

2715