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 flat file which contain only one column with data type varchar.now i want to send string data types into one target and if any numbers and special characters are there that should be send it into another target.so how do you design a mapping for this?

Answer Posted / vijaya

By using function isnumber(), is string() in expression editot you get the solution

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is rank transformation in informatica

1107


what is Active lock explain

2727


TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com

1805


What does update strategy mean, and what are the different option of it?

1035


What is joiner change?

1078


What do you mean by worklet?

1017


Briefly explain the aggregator transformation?

941


What is joiner transformation?

948


What is sq transformation?

1079


What is a stored procedure transformation?

989


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1907


What is the use of target designer?

980


What does “tail –f” command do and what is its use as an Informatica admin.

1029


What is the sql query overwrite in source qualifier in informatica

1026


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?

1603