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

While migrating the data from one environment to another environment how would you manage the connections?

1047


Write the unconnected lookup syntax and how to return more than one column.

1049


I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.

1585


What does reusable transformation mean?

1069


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7072


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

2057


What is the advantage of informatica?

1013


What is a router transformation?

1047


Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com

1975


How are indexes created after completing the load process?

1545


What is informatica?

1077


What is the use of code page?

1010


What does “tail –f” command do and what is its use as an Informatica admin.

1029


What are the reusable transformations?

1097


What is the difference between informatics 7x and 8x and what is latest version?

1023