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.
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
How can we use mapping variables in informatica? Where do we use them?
To import the flat file definition into the designer where should the flat file be placed?
What does “tail –f” command do and what is its use as an Informatica admin.
How to implement security measures using repository manager?
How to extract sap data using informatica?
What are the different lookup cache(s)?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is pmcmd command?
What are the popular informatica products?
what is size of u r database?
Briefly explain the aggregator transformation?
what is the size of your data warehousing?
How can we update a record in the target table without using update strategy?
What are the differences between oltp and olap?
What is joiner transformation?