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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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.

Question Posted / bharu_295

Answers were Sorted based on User's Feedback



hi guys i have an question how do you find out weather the column is numeric or combination of c..

Answer / 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

hi guys i have an question how do you find out weather the column is numeric or combination of c..

Answer / abhishek kumar

IN EXPRESSION
FLAG->OUTPUTPORT
IIF(IS_NUMBER(ID),1,0)
IN FILTER
CONDITION
FLAG=1 (RETURN NUMERIC )
OR FLAG=0 IT WILL RETUN ALPHABETIC CHARACTER

SECOND WAY
IS WE USE ASCII() FUNCTION
ASCII(ID)>64 IT RETURN ALPHABET
ASCII(ID)<64 IT RETURN NUMBER

THANKS
ABHISHEK GUDDU

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

What are the joiner caches?

3 Answers   Informatica,

In warehouses how many schemas are there?

0 Answers  

How Union Transformation is an Active Trans?

6 Answers  

What is complex mapping?

0 Answers  

What is a repository manager?

0 Answers  

i having mapping emp---> sq_emp--->target using this mapping i have to load dept table values into target... (condition assume there is no primary and foreign key relation between emp(table x) and dept (table Y))

5 Answers   Cap Gemini,

In dimension and fact table? which one holds big data?

2 Answers  

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,

what is incremantal aggregation?

1 Answers  

Under what condition selecting sorted input in aggregator may fail the session?

0 Answers  

my session have to run Monday to Saturday not run sunday how to sedule in informatica level?

1 Answers   Infinite Computer Solutions,

What are the various types of transformation?

0 Answers  

For more Informatica Interview Questions Click Here
Categories