IN EXPRESSION FLAG->OUTPUTPORT IIF(IS_NUMBER(ID),1,0) IN FILTER CO

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 / abhishek kumar

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

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What are the steps involved in the migration from older version to newer version of Informatica Server?

2112

How do you load first and last records into target table?

1159

How does the aggregator transformation handle null values?

1150

Explain incremental aggregation in informatica

1134

in reporting we add some new objects,how we get the count of the newly added objects to the report

2200

Repository user profiles

1767

How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.

1786

How to elaborate powercenter integration service?

1137

If informatica has its scheduler why using third party scheduler?

1269

Enlist the advantages of informatica.

1069

As union transformation gives UNION ALL output, how you will get the UNION output?

1109

What is meant by LDAP users?

1211

pmscmd startworkflow -sv -d -u -p -f while running this command I got the error as "no gateway connectivity is provided for your domain name". So anyone please help me how to rectify this error?

1512

Differentiate between sessions and batches?

1021

What do you mean incremental aggregation?

1082