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

How to do the error handling of if ur source is flatfiles?

1968


Design a mapping to load a target table with the following values from the above source?

1347


Does an informatica transformation support only aggregate expressions?

1042


Explain sessions. Explain how batches are used to combine executions?

1034


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

1116


Enlist the advantages of informatica.

1068


if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.

2201


What is an expression transformation?

1017


I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?

1767


What are the types of schemas we have in data warehouse and what are the difference between them?

942


How to create Target definition for flat files?

1227


what is song in infrmatica...?

2237


Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.

2305


Dimension Object created in Oracle can be imported in Designer Cubes contain measures

2399


Can we get 1st record through Informatica(without sequence number).

1479