hi guys i have an question how do you find out weather the column is numeric

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

2 Answers
6775 Views
IBM, I also Faced
E-Mail Answers

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

Explain informatica architecture - version 8 / 9

0 Answers Informatica,

Enterprise data warehouse your projects phase by phase explain?

0 Answers Cap Gemini,

I have id, seq_no date, bill_amt and weight 1,11,'01-Jan-2014',100,2 2,12,'01-Jan-2014',40,5 3,13,'01-Jan-2014',32,5 4,14,'01-Jan-2014',98,2 5,15,'01-Jan-2014',105,3 6,16,'01-Jan-2014',11,3 1,11,'02-Jan-2014',40,2 2,12,'02-Jan-2014',100,5 3,13,'02-Jan-2014',132,5 4,14,'02-Jan-2014',198,2 5,15,'02-Jan-2014',15,3 6,16,'02-Jan-2014',16,3 Now I need output as date MXAMT_LSTWGHT MINAMT_GRTWGHT 01-Jan-2014 100 32 02-Jan-2014 198 100 Could not think of mapping to do so. Please help

1 Answers Axtria,

tell me 5 session failure in real time how can you solve that in your project?

0 Answers CSC,

I have name like INDIA in a column. I want display 1st line A, 2nd line N, 3rd line D, 4th line I, 5th line A in oracle data base?

1 Answers Cognizant, HCL,

how many session run unix environment what command using ?

1 Answers HCL,

what is correlated query?

2 Answers IBM,

1 2 3 * 4 5 6 * 7 8 9 how to load records between two stars(*),

10 Answers Cap Gemini,

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.

0 Answers CTS,

Is it possible to have "5 source & 5 Target" in single mapping?

1 Answers

i have two flat files.. containing same type of data i want to load it to dwh..how many source qualifires i need

7 Answers Deloitte,

In mapping f.f as one src and f.f as trg,f.f as src and oracle as trg which is fast? mean which is complete first process

2 Answers Wipro,

For more Informatica Interview Questions Click Here