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 / kamlesh mishra

Use is_number(field) and not is_number(field) functions in router transformations

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways are there to create ports?

1321


in reporting we add some new objects,how we get the count of the newly added objects to the report

2186


What are ETL Tools?

1109


Enlist the differences between database and data warehouse.

1113


The question was on time stamp. what is the difference between HH and HH24 when to use when.

2049


Tell me about Propagate functions in informatica

915


How to update source definition?

1082


Is there any target staging area in informatica not staging area

2572


what is the Default Source Option For Update Strategy Transformation?

1228


What are the different types of olap? Give an example?

1046


How does a rank transform differ from aggregator transform functions max and min?

1194


Where are the source flat files kept before running the session?

1067


In informatica workflow manager, how many repositories can be created?

1346


lookup transformation with screenshots

3997


What is lookup change?

1044