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

What are your source in project and how you import in informatica? How can i explain abt this?

1 Answers Accenture, Unisoft Infotech,

Explain in detail scd type 2 through mapping.

0 Answers

HI Experts, What is BULK mode and NORMAL mode, Which one gives better performance. How? Please Explain with an example...! It will help's me a lot. Thanks In advance.

8 Answers CTS,

Hi, In a mapping I have 3 targets and one fixed width file as source. Total 193 records are there . I connected one port in aggregator to all 3 targets. The same value need to be load into these 3 targets . It is loaded like that only but in different order. Why? The order of insertion should be same know for all 3 targets ? Then why the order is changed ? Any one please help me. Advance thanks.

3 Answers IBM,

why sequence generator should not directly connected to joiner transformation ?

1 Answers ANZ,

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers

what is the incremental agrrigation?

2 Answers Cap Gemini,

what are surrogate keys?

5 Answers

Explain the difference between mapping parameter and mapping variable?

0 Answers

In incremental loading using Mapping variable if session failed with any of reason in the middle of process. is the Mapping variable remains constant or change?

1 Answers TCS,

i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers TCS,

My sql query is 1. select 1+x from dual? 2. select 1+'x' from Dual? 3. Select x+1 from dual? what is the out put of the above queries?

3 Answers HP,

For more Informatica Interview Questions Click Here