1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

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

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

source name sal aaaa 2000 bbbb 3000 abcd 5000 Target name sal aaaa 2000 bbbb 3000 abcd 5000 total 10000 how to get total as new row and sum as 10000 thanks

4 Answers   Polaris,

Had any one faced informatica(ETL/Developer), Datawarehouseing interview in UK. Than plz help me (i have any exprience of 3yrs informatica,datawarehousing,oracle,teradata) 1.hw the procedure will b here 2. wht type of question's they will b asking. 3.In which area they concertate more. since this is the first time im facing interview in UK. plz help ASAP.it will b a great help for me thanks to All in Advance

2 Answers  

I have 2 Sources,If 1st one Read sucessfully,Then only it has to move to read 2nd source.How can i do in INFORMATICA.

4 Answers  

Describe data concatenation?

0 Answers  

how eliminate the duplicates in flat file with out using sorter ,aggregater

4 Answers   Wipro,




How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how

0 Answers   CTS,

What are parallel querys and query hints?

1 Answers  

what is data driven in informatica

5 Answers   IBM,

when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  

what is plsql table?

2 Answers  

WHat all joins are there in Source Qualifier?

1 Answers  

What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

2 Answers   TCS,

For more Informatica Interview Questions Click Here
Categories