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

State the limitations where we cannot use joiner in the mapping pipeline?

1060


What is xml source qualifier transformation in informatica?

1217


What is meant by query override?

1055


What is data movement mode in Informatica and difference between them?

1129


What is the surrogate key?

1252


How to configure mapping in informatica?

1170


permutations of mapplet

2509


What are the uses of etl tools?

1121


What are the types of data warehouses?

1515


What is the use of code page?

1083


Partition, what happens if the specified key range is shorter and longer

2487


What is target designer and target load order?

1101


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

1118


What do you mean by DTM and Load manager and what is difference between load manager and load balancer?

1144


What are the types of lookup transformation?

1070