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

can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project

2519


How can you differentiate between powercenter and power map?

1091


What is an expression transformation in informatica?

1039


How can informatica be used for an organization?

1220


can you please explain me pre session and post session options?

7569


how many types of dimensions are available in informatica?

1100


In informatics server which files are created during the session rums?

1115


Define mapplet?

1013


What is decode in informatica?

1165


draw informatica architecture 8.6 ?

3873


According to his methodology what all you need before you build a datawarehouse

1759


How to do unit testing in informatica?

1173


Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

2049


Explain sessions?

1066


What differs when we choose the sorted input for aggregator transformation?

1025