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
6806 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 the types of lookup caches?

10 Answers Accenture, IBM, Informatica,

3,if our source containing 1 terabyte data so while loading data into target what are the thing we keep in mind?

7 Answers TCS,

What is the procedure for creating independent data marts from informatica 7.1?

0 Answers

As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers

What are active transformations.

0 Answers

On lookup on any table we can get only a)any value or b)last value but if i need both duplicate values How can i achieve?

3 Answers

Hi all, i am new to this site and new to Informatica too. I have few questions regarding that. 1) When we load flat files into target tables how do we identify duplicates? and where do load the duplicate records for further reference? 2) How do we do chage data capture? Is this Slowly changing Dimension technique? Thanks in Advance

3 Answers

What are the hard ware required for a normal sized data warehouse? and What are the software required for a normal kind of data warehouse?

2 Answers CTS,

Session S1, S2, and S3. In the session S3 I want to load every Saturday. How it is possible?

2 Answers TCS,

without table how to come first record only in oracle?

0 Answers

HOW TO JOIN THE 2 FLAT FILES WITHOUT USING JOINER AND LOOKUP?

11 Answers Cap Gemini,

Why we select the table which has minimum number of records as Master table in joiner?

4 Answers HG, UST,

For more Informatica Interview Questions Click Here