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

hi guys
i have an question how do you find out weather the column is
numeric or combination of char and numbers or it contains
char,numeric and special characters.

Answer Posted / abhishek guddu

In Expression t/f
flag--
iif(is_number(id),to_integer(id),to_char(id))

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In how many ways we can create ports?

1157


what are 3 tech challenges/ common issues you face?

2394


How to do unit testing in informatica? How to load data in informatica ?

1181


What is meant by lookup transformation?

1180


What are the different lookup cache(s)?

1165


How to extract sap data using informatica?

1092


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

1130


Define mapplet?

1058


How you know when to use a static cache and dynamic cache in lookup transformation?

1916


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3921


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

2247


What are the differences between joiner transformation and source qualifier transformation?

1235


Can we create a node as a gateway node and the same node can be assigned to a grid?

1125


tell me about your project functionality

2381


Is it possible to define a single node as a Gateway node as well as worker node?

1184